Combobox adding record to wrong table

[LisaG]

Thanks so much for your reply. I think I understand your project.

My child table that adds a record to the parent table would never have the ID missing in the parent table.

Does the query for your form join the child and parent tables? Mine does and that seems to be the problem. When I remove the join to the parent table, the form works fine. I tried using DLOOKUPS for the values from the parent table that I want to display, but they populate soooo slowly.

 

[lydonw]

For the form that pops up (with the on open event) the source is a table. It may be that our issues appear similar but the causes differ?

DLookup is slow, especially as you get more data, but in this case I'm only using it for a singular event that is infrequent, and so it was an acceptable solution for me. Sorry I couldn't be of more help. Good luck

 

[LisaG]

I thought of that - using another form to add records. I think I might have to do that. And yes, I can use DLOOKUPs when it's just one record.

Thanks again for replying!