subform one to many error

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a subform on a form linked by the main form's primary key with the
subform based on a table that represents the many-side of the relationship.
All was working fine until all of a sudden I now get the following error:
"The current field must match the join key '?' in the table that serves as
the 'one' side of one-to-many relationship. Enter a record in the one side
table with the desired key value, and then make the entry with the desired
join key in the 'many-only' table." A record is created on the main form
(creating a new record in the 'one' table) before making an entry on the
sub-form and was working fine. Can anyone shed some light on why this error
has just surfaced? Thank you.
 
Bob,
I've had the same problem and got an answer through the forum at
www.utteraccess.com
This is a bug in Access that only happens when you have any default values
in any of the Controls (text boxes etc) on the subform. Remove all default
values and it works. Another condition that seems to be necessary for the Bug
is that the One side of the relationship be an Autonumber ID field. I've
tried to find out if MS have released a bug fix yet, but so far no joy.
Hope this helps, Nat.
 
Back
Top