MS Access How to control a drop down state when another field has text?
Posted on 2013-01-25
I have a drop down with 3 selections:
No user interaction with this drop down is desired (locked).
How do I want to automate when inputting or updating a record:
If a task name is inputted - drop down = Working
If a completion date is inputted - drop down = Complete
If the Cancelled radio button is selected - drop down = Cancelled