Hi, I am new to Access 2007 and I am having trouble in creating a form.
It is simply a data storage table which would be fed in by users. That it.
I need to create a user friendly form so that :
When the user selects : Career_Goal field as "None", the next field called: Years, should be automatically be populated as 0.
In any other case, they should be able to select the years from the dropdown list.
How do I create this if else conditions? Do I use expression builder, if yes then how?
Grateful for your help.
Thanks