Require data to be entered

[angie]

I have two text box (1) excetpedDate (2) exceptedBy I would like the exceptedBy text box to be required if the exceptedDate text box has a date.



Thank You Angie

[June7]

Maybe field and/or textbox names should be AcceptedDate and AcceptedBy?

You can set the fields in table as required and let Access nag users. Or use code behind form to validate data before record committed.

[angie]

Maybe field and/or textbox names should be AcceptedDate and AcceptedBy?

You can set the fields in table as required and let Access nag users. Or use code behind form to validate data before record committed.

I would like to use code

if me.status is “accepted” than
me.acceptedby is required
End if

not sure how to word the required.

Thanks Angie

[June7]

I forgot to mention ValidationRule and ValidationText properties of textbox.

There are many examples of validation code in form BeforeUpdate event.