Hi there

I'm new to this game so I hope my question is not to simple.

I would like to make a combo box in a query that is previously use in the main flat table that I have. So when the query is prompt the user will have the list to choose from. ie

SELECT Contacts.Title, Contacts.FirstName, Contacts.LastName, Contacts.Category, Contacts.Home_PhoneNumber, Contacts.Home_CellPhoneNumber, Contacts.Business_PhoneNumber, Contacts.[Business_Cell phone]
FROM Contacts;

The Contacts.Category is the combo box that I would like the user to choose from. This means that if they choose friends then all of the friends contacts will appear etc. This will then be made into a report.

Can any body help me on this one.