G
Guest
Hello,
I have an account cancellations db (access 2002) for the company. I need to
have certain fields of the dB required (not left blank). However, these
fields should only be required to be filled in when a status field is changed
to "closed" from the drop down box. Status field has other selections such as
new, not valid etc...
Is there anyway I can use a micro or formula to create a link between status
field "closed" and other fields which become required (not left blank) when
status changed to "closed"? I appreciate all your help. Thank you.
I have an account cancellations db (access 2002) for the company. I need to
have certain fields of the dB required (not left blank). However, these
fields should only be required to be filled in when a status field is changed
to "closed" from the drop down box. Status field has other selections such as
new, not valid etc...
Is there anyway I can use a micro or formula to create a link between status
field "closed" and other fields which become required (not left blank) when
status changed to "closed"? I appreciate all your help. Thank you.