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...