Unanswered: Using a combo box to filter records on an access form
I'm attempting to filter records on my form based on the drop down values of a combo box. However, I'm trying to filter the records of two different fields based on the value in a single combo box. Both fields (Site_A) and (Site_B) contain the same type of data and the value that I choose in my combo box may appear in either field. The following code allows me to sucessfully filter based upon of the two fields:
However, I'd like to add (Site_B) to the mix so that the form records will be filtered when the value I choose in the combo box appears in either or both the (Site_A) and (Site_B) fields. I'm very new to visual basic but it seems like I'm probably just overlooking something simple. Is there a simple "and/or" like function I can add to the above code?