using a combo box in a query

[Teeboy]

In the criteria field of a query's design view you can surround a phrase in square brackets and this forces a msg box prompting you for some data relative to the field it was placed....... The problem with this is you have to type in exactly what is in the table... Question is can i use a combo box in the criretria field?

 

[Dugantrain]

You can't use ActiveX controls from inside a query, you'd need to call this query from a form. The first thing that you would do is to create a Form and drop an Unbound Combo Box onto it. Follow the Wizard and specify its Row Source. Then, back in the query, in the Where Clause of the field which relates to the fields in the Combo Box, transcribe the following:

Forms!Your_Form_Name.Form!Your_Combo_Box_Name

Of course, replace my generic form and combo box names with your names. Last, you'd call this query in the AfterUpdate event of your combo box like:

Your_Combo_Box_AfterUpdate()
DoCmd.OpenQuery "Your_Query_Name",acviewnormal,acedit
End Sub

Make sense?