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.
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.
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.
Thank you. Good and simple idea.
No problem; post back if you get stuck.