Automation-object

  • Thread starter Thread starter Mercedes Marotta
  • Start date Start date
M

Mercedes Marotta

I get an error, the same discribed on article 209622, on
Access 2002. But I don't have a SetValue macro or
function. On the same message window I get also the error
discribe on the article 123653. But I don't have the name
of a form property on my subform.
The problem is present when I try to add a new record on a
subform based on a query. On this query are 2 tables
present with a 1:N realtionship. I need this query to be
1:1 so I added a Where clause on it, so I have only One
record from the N sida. And the connection with the main
form is related 1:1. I know that is better to have 1:N
connection with the subform, but nowhere is said that it's
not possible to do a 1:1 connection between main form and
the subform.
Thank you for any help.
 
Mercedes,

No, it is not impossible to use a 1:1 query as a basis for a
subform, but the problem is it will not be an updateable
query. Think about the problem Access is having when you are
asking it to add new records to two tables at the same time.

It sounds like you are forcing both 1:N relationships to be
1:1 when they shouldn't be. Maybe you could give more
details of what you are actually trying to accomplish and
someone may have a better approach.

Gary Miller
 
THANK YOU Gary!!!
You opened my mind. I changed the relationship and it's
working now.
Much obliged
Mercedes
 
Glad you got it working.

Gary Miller

Mercedes Marotta said:
THANK YOU Gary!!!
You opened my mind. I changed the relationship and it's
working now.
Much obliged
Mercedes
Click to expand...
 
Back
Top