Making one field or another mandatory to fill

[Mohamed]

Hi
I have a form where I would like one of two fields mandatory to fill.
I have an encryption password field and a pen drive password field. I would it so when the user tries to close the form, one of these two fields has to be filled in.


How would I acheive this?
Any help will be much appreciated
Thanks

[orange]

This link
http://office.microsoft.com/en-us/ac...010096312.aspx

has info on Validating Data During Entry in Forms

This article may be useful also
http://www.techrepublic.com/article/...access/6154743