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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Prevent saving of main form without related record in subform

Status
Not open for further replies.

rooterr

Technical User
May 15, 2001
21
0
0
US
I have a project based database. Where you enter a project with the persons responsible Form:stratnewF. With a subform where you enter the action items to complete the project Form:stratnewsubF. I have had problems with people entering in a project and person responsible and then exiting the database without entering in the related action items. How do I prevent them from leaving the database or the database from saving the information without the related subform being filled out.

Thanks,
RT
 
Check for the subform fields being equal to null. If null then do a me.undo Me is another name for the current form.

Rollie E
 
Rollie, thanks for the suggestion. I am a little bit new to all of this. Where would I put the undo at?

Thanks,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top