Then something has changed to stop it working as it didYes, the form was working previously, and now is not.
Cannot add record because a related record is requires in table
Access Developer
Windows 10 
Access 2016
Then something has changed to stop it working as it didYes, the form was working previously, and now is not.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Advanced Beginner
Windows 10 Access 2016
You are correct. I knew that in the back of my mind, I just could not spot it.Originally Posted by Bob Fitz
As I mentioned, it got messed up when I copied it. Basically, in the Row Source when you click the elipse, and build the query to locate the info from the tblIncInvoicesC, that information got lost which is why it reverted to a Row Source of tblIncInvoicesC. I see that now and I have just corrected it by redoing all of the queries associated with each combo box.
I appreciate the help. Sometimes it just takes fresh eyes, and a little explanation, to get the brain back on track.
Much appreciated.
Access Developer
Windows 10 Access 2016
You're welcome. Glad to help if I can
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
New Record Requires a Related Record
can't change or add record because related record is required it table?
Posting Permissions
Reply With Quote