querying a form

[Graybeard]

I have a form with fields for 3 phone numbers for a client-home, work and cell, plus fax and email address. I want to write a query that will allow the user to allow the user to look up a clients phone numbers. I have three questions. First, I'm not sure where I want to put the query. Do I want an unbound popup form with the combox? Or something else? Second, Can I use one query to look up all 3 phone numbers plus the fax number aned email address? third, is it possible to write code to allow the user to chose which of the 5 fields they wish to search for?

 

[stephen81]

I've attached a sample which might give you what you need. It's fairly basic and might need changing depending on how you are storing the contact details. If this doesn't help, if you can post your database I'll have another go.