Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot add or change record

Status
Not open for further replies.

Heeeeelp

Technical User
Jan 5, 2006
39
CA
Hi Everyone,

I have a form called orders and a subform called Order Details. When I try to enter information in the subform, I'm not able to save the infomation. A message displayes stating, cannot add or change record as a related recorded is required in the tables order. The two forms are linked by the Order ID. When the form, Orders loads, I do see the Order ID changing to the next available ID number. I'm not sure what the problem is. This was working a couple days ago.
I would appreciate any advise on how I may be able to fix this problem.

Thank you,
Tess
 
Seems you've lost the LinkMasterFields and/or LinkChildFields properties of the subform.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
or your entering a new record in the subform without entering a new record in the mainform 1st!

Calvin.gif
See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top