Recent content by Pharmer Rob

Thanks so much. I've been agonizing over this for a while.

Maybe I'm not understanding, but wouldn't a list box serve this function?

Thank you so much for the help. What I am looking for is what Dave is describing in the search criteria routine. I want the user to be able to enter a last name and/or first name and/or d.o.b. and filter the recordset. I have attached the search form that I want to use to filter the records...

I have used parameter queries in this way. But I wanted to be able to enter any combo on my search form, hit a search button and retrieve the records that meet the criteria in a list box or something like this. Thanks for the rapid response. I've looked in several books. I don't see this...

I am new at this so bear with me. I have created a database to track patient visits. I want to go from my switchboard to a search form that can search records by a combination of Last Name, First Name and D.O.B. I have made one that will search by one criteria not using VBA. Keep in mind I'm...