ms access forms with subforms commad


We have a form with a command button in the main form and a tab with 3 subforms of different record types. In the subforms i have a check box, that when is checked it makes 3 fields visible. The problem that i have is that if a user checks the box but does not enter information in the fields, when they press the command button in the form it takes them out to the main menu and won't let me edit the fields.  I tried putting code in the close event of the subforms to cancel the command button event in the form and display a message if not entry was made in the fields but nothing works.  I also tried the unload event with no success.

I put code in the check box click and on current events to make the fields visibles.

 
 
ShenAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
or use the beforeupdate event of the form to check for controls/fields that are not filled

see codes from this thread

http://www.experts-exchange.com/Database/Miscellaneous/Q_22653980.html#a19351039
0
 
Rey Obrero (Capricorn1)Commented:


<...when they press the command button in the form it takes them out to the main menu >

here is one way to make this work.
you can set the enabled property of the command button to No as the default.
Enable the command button only when an information was entered to the controls/fields.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.