ComboBox Code Selction for Activation of a field fliter code requesting Query

[justphilip2003]

Is it possible to use a ComboBox to select a filtering code in an AfterUpdate() EP for a "DoCmd.OpenQuery "qryOpenStockbyWoodType", , acReadOnly"? I wish to feed the Query this filtering code in order to remove the messiness of the MsgBox display and the short comings that the user would know all possibe codes which a Combox can supply. The Query works find. The ComboBox works fin in another form. The issue is how to feed the code to the Query. TIA Phil

[pbaldy]

Personally I never open a query for the user to view, but you could have a reference to the combo in the appropriate field's criteria. Opening a form or report you could also do this:

http://www.baldyweb.com/wherecondition.htm