Error message in Remote copy - Microsoft Access Expert 23


	Back to Access Expert 23 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Error message in Remote copy

Robert Taplin

5 years ago

Hi Richard,
When I try to add a new record in ContactSubFormF (15:19 in the video), I get error message: You cannot add or change a record because a related record is required in table "CustomerT". There is a notes field in CustomerT and the entries line up with the existing records that show in ContactSubFormF. Thank you, Bob Taplin

	Richard Rost @Reply 5 years ago
Sounds like you're trying to add a child record without a related parent record.

	Robert Taplin OP @Reply 5 years ago
For the previous note lines, the customer name is in the CustomerID combo box. When I tab to "new" note line, the CustomerID combo box goes blank. The control source for the CustomerID combo box is CustomerID, and the Row Source is: SELECT CustomerID, FullName, CompanyName FROM CustomerComboQ ORDER BY FullName;. All those items are in CustomerComboQ.

	Robert Taplin OP @Reply 5 years ago
I figured it out. The default value for CustomerID combo box was to blame! It is fixed and now works.

	Richard Rost @Reply 5 years ago
Yep. Like I said. :) LOL If you don't set that default value then when you add new records to the subform, it doesn't create that relationship.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 23.

Next Unseen