Upon activating a form with a record, I want to either enabled a command button or disable based on another record field value. I can do in excel with a user form, but do not know how in Access 2013
Upon activating a form with a record, I want to either enabled a command button or disable based on another record field value. I can do in excel with a user form, but do not know how in Access 2013
The best place to do that is probably the On current event:
You have to include the "else" part because some records might meet the condition, others won'tCode:If me!testfield = somevalue then me!commandbutton.enabled = True else me!commandbutton.enabled = False endif