1. Open your table in design view.
2. Open the Properties box (View menu).
3. Beside the Validation Rule in the the Properties box, enter something
like this:
([ret_ref] Is Null) OR ([qty_refused] Is Not Null)
The rule can be satisifed two ways:
- if ret_ref is Null, it's happy;
- otherwise, the only way it can be satisfied is if qty_refused is not null.
Make sure you use the Validation Rule in the Properties box (i.e. the rule
for the table), not the one in the lower pane of table design view (which is
the rule for a field).
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mark Reed" <ma*********@nt lworld.com> wrote in message
news:3G******** *****@newsfe2-gui.ntli.net...
This is probably a really simple question but I have been unable to
figure it out. I have a field ([qty_refused]) which needs to have a value
entered by the user but only if another field ([ret_ref]) is not null. By
I have set the default value of ([ret_ref]) to null. I can't set the
"required" value of the field to yes as it isn't required all the time and
haven't been successful trying to set a validation rule.