Combo Box to find values in 1 of 2 fields in query and return reco

P

Patricia

I have a form that I want to use a combo box to find the record in the query
if the value matches the value of 1 of 2 fields in the query. I can make it
work on 1 field, but do not know how to make it look at both fields and
return the data.

Ex: The combo box has the values for all the monday dates of the year. I
want to pull all the records in the query that matches the field for invoice
date or paid date.

Thanks
 
Top