I am trying to open a Form using a command button on an exiting form. One condition is based on a date field, one on a text field and the other on a text field saved from an option group. Not sure whether to use the looked-up text or the numeric value for the option group field value. Using the wizard, gives me the first condition:
="[pp_end_date]=" & "#" & [pp_end_date] & "#"
text field =[Employee ID]
option group field = [Pay Type] 1="State", 2="Osha"
Don't know the syntax for 1 never mind 3 conditions. Any help is appreciated.
Thanks
="[pp_end_date]=" & "#" & [pp_end_date] & "#"
text field =[Employee ID]
option group field = [Pay Type] 1="State", 2="Osha"
Don't know the syntax for 1 never mind 3 conditions. Any help is appreciated.
Thanks