selecting query criteria

[geoffreyp]

Is it possible to use a form to select criteria for a query?
I have tried putting =[forms]![fExhibitionSelect]![ExhibitionSelect] into the criteria with the result of being asked for a parmeter valu of the same name ie. =forms !fExhibitionSelect !ExhibitionSelect

I have also tried putting in the controls(on the form i have created to hopefully select the query critreia) afterupdate prop a macro that opens the report i want AND in the where condition have used the expression builder to put in the afetrupdate value from the control on the loaded form.

Both gave no result. any assistance greatly apprciated

 

[Brianwarnock]

yes, if you are still being prompted check the spelling also make sure the form is open.
I always work from a form with the command button to fire the query, this also ensures that the data is entered.

Brian

 

[thingssocomplex]

I am not sure how you are doing this, but you can use a combo box (name your combo box to something similar to CmbReportName in the query criteria enter [Forms]![Name of your user form]![CmbReportName] - you then can add a button and use the OpenReport using DoCMD.

 

[geoffreyp]

Thanks for your help, i have got it work with the direction you have given me and of course, much playing around till it DOES work.
cheers