Making Fields Required Based on Input in Another Field

[alpinegroove]

Is it possible to make a number of fields in a form required based on what a user enters in another field on the same form or subform?



Thank you.

[pbaldy]

I'd use the before update event of the form:

http://www.baldyweb.com/BeforeUpdate.htm

First testing the other field, then the optionally required fields if appropriate.

[alpinegroove]

Thank you. Good and simple idea.

[pbaldy]

No problem; post back if you get stuck.