Multiple Form and Updating (1 Viewer)

[JudyHNM]

I have a main form where I enter membership information. I then click on a command button to go to another form to enter the actual member detail. When I exit the member detail form, it works fine IF the record was previously existing in the membership info database. If it's a new record in the membership info form, then, (even thought the correct index number shows up on the member detail form), it won't let me save the member detail information. I get a message that says it can't save the member detail without having an entry in the member info database. What can I do to force that entry in the member info database?

Thanks, Judy

 

[pbaldy]

Try this to save the record before going to the detail form:

DoCmd.RunCommand acCmdSaveRecord

 

[JudyHNM]

Thank you so much. That worked perfectly.

 

[pbaldy]

No problem, Judy. Glad it worked for you.