Field Required from other field.

[outlaw318]

Wasnt sure were to put this, but here it goes. I have and two fields in my requisition table. One is EmergencyDate and the other is EmergencyUse. If EmergencyDate is filled in the EmergencyUse would be required. I searched the boards, but I guess I didnt know how to search it. Any suggestions?

 

[jeremie_ingram]

Go into design view for the table, and set the field as REQUIRED = YES and the database will not save the record unless it is filled out.

 

[outlaw318]

The field is only going to be required based upon another field. If someone puts in the emergency date then they must fill out the emergency use.