Prevent user from adding subform record if main form has null value

[Jojojo]

Is there a way to keep a user from bring able to enter a record in a subform, or giving a message if they try to add a record to a subform, when a certain value/field is null on the main form? The subform consists of a combo box and they do not have to click a cmd button to access the subform. The field in the main form is also a combo box.



My user has a tendency to skip the main form and enter the info into the subform and then forget to enter the info into the main form all together. I do have required fields built into the table, but because she is closing the form without entering any info into the main form, it doesn't kick in the required fields. She thinks she's entered a record but it's incomplete.

[NTC]

simply toggling the visibility is one way, or toggle the lock property of the control or form or toggle the enable property....... kinda sorta just depends on what is the better user interface....

I tend to toggle visiblity, revealing more and more as the user progresses thru a form so that they stay on the straight & narrow.....

[robsworld78]

On the subform you don't want the user to access set the "visible" property to no or the "enabled" property to no.

Then choose which field you want to have the subform become visable or enabled again and in the "AfterUpdate" event on that field add the code

Me.SubformName.Enabled = True

or

Me.SubformName.Visible = True

Now when the form opens the subform will be disabled or hidden and once a user enters data in the field you chose the subform will reappear or be enabled.

You should do this to all the fields so a user has to enter data the way you want it entered.

You can also use the same code anywhere with "False" instead of "true" and that will hide or disable what you tell it to.