Help with error: No corresponding record on the "one" side

[moishier]

I have a form that I am using in datasheet view.

This form has as the control source a query that join two tables in a one-to-many relationship.

Recently, when I try to add a new record via the datasheet it does not let me update the second part of the join, with an error "No corresponding record on the "one" side".

I understand that it's because the parent record was not yet created.

I don't want to use a subform.

How can I get this to work as it used to?

 

[spikepl]

Recently, ... it does not let me update.

So it DID work.

What changed? Did you modify your db?

IF not then it is the data. So what changed in the data? Try run with old data

 

[moishier]

I have no idea what changed. I was asked to fix a problem and have no idea how it used to be.

 

[spikepl]

Did anybody modify db? Get old version.

Did data change? Check with old data.

 

[James Deckert]

Did the record get added for the parent? Try inputting only the parent data, move to the next record, then move back and enter the child data to see if that works. Open the parent table also and see if/when the parent record is added.