Help with Subforms!!!

matt123

Registered User.
Local time
Today, 18:23
Joined
May 11, 2001
Messages
13
HELP! I have inserted a Sub-Form the ID of the subform is related to a field in the Master form. When data is entered through the several fields and comes to the last field (before it should tab to the Sub-Form) I get and error message that reads "You cannot add or change a record becausea related record is required in table (where it mentions the underlying table of the subform). Anyone who can help is life saver.
 
Last time I got that message the relationship was the wrong way around, check that.
HTH
 
Dear Rich
I am sorry, but I dont understand that. Could you elaborate a little? Thanks for your help.
Matt
 
Your relationship is one-to-many and you have used the "many" side table as the mainform recordsource and the "one" side as the subform's recordsource. These need to be reversed since you must enter data into the "one" side table before you can enter related records in the "many" side table. Take an Order and OrderDetails as an example. You must enter an order before you can enter any items related to that order.
 
Thank you both! The lightbulb went on, and that was exactly what I needed to hear.
 

Users who are viewing this thread

Back
Top Bottom