Competent Performer
Windows XP 
Access 2003
I am trying to make certain controls/fields requried and a combo box has a certain thing selected. I was attempting something like:
But that does not work of course.Code:If Me.Category.Value = "Activations - PostPay" Then Me.batchnumber.Required = True
Does anyone have any ideas?
Who is John Galt?
Windows XP Access 2007
I don't know that you can change the required property like that. I'd use the before update event of the form:
http://www.baldyweb.com/BeforeUpdate.htm
Hide/Unhide multiple fields based on selected combo box value
Filtered Combo Box in Subform based on Combo Box in Main Form
Limit combo box 2 values based off of combo box 1 selection
Posting Permissions
Reply With Quote