Combobox won't update record

[Guest]

I have a form based off of a query with a combobox that looks up information
from TableA and the selection updates an existing record in TableB. I used
the Access wizard to set it up, which I've done many times before but this
time, for some reason it will not take the selection. A the bottom of the
screen I see the following message: (I made the table name generic for less
confusion)

"records in B table would have no record on the 'one' side"

I'm assuming the 'one' side it's talking about is the table that I am
getting the information from (TableA); however, TableA has a 0ne to Many
relationship to TableB.

Thanks in advance for your help,
Al

 

[Allen Browne]

Does this problem occur with existing records (not just the new record row)?

Yes:
Open the query in design view. Make sure you have the field from TableB in
the output grid of the query, and not the field from TableA (the lookup
table.) Your form needs to be setting the value of the field in the related
table, not the table from the "one" side of the relationship.

No:
If the problem occurs only with the new record row, then open TableA (the
lookup table) in design view, and remove the Default Value property from all
fields. When you are trying to add a new record, Access (wrongly) tries to
apply the Default Value for all fields in the query, and naturally enough it
fails when it tries to create a new record in the Lookup table as well.