I apologize in advance for my knowledge base. I am decent at developing databases using all of the canned features and query tools in Access. I am trying to learn VBA.
I am trying to filter 2 fields using as input the selections in a drop down combo box and an option box.
I have a combo box [CustomerSelect] that filters a customer name. (which by the way I don't completely understand the ampersand usage. another topic)
Me.Filter = "CUS_CorpName = """ & Me.CustomerSelect & """"
That works fine. Now I am trying to filter that further with my option box.
I have an option box [WOStatus] to select "Released" or "Complete" work orders using the values 1 or 2. The field I am trying to filter is [WKO_StatusCode]
If Me.WOStatus = "2" Then
Me.Filter = "WKO_StatusCode= 'Complete'"
Me.FilterOn = True
Can you help me with the correct syntax to filter both fields in one statement?
Inexperience and confused.