Access Query Data Selection

[woody66]

Hi

I have a report that runs depending on the results froma query. I have a couple of fields that the user is prompted to input their data selection. 1 field is a date and the other is a site reference.
What I would like to do for the site reference is to have a drop down box with all the sites listed (there are only 2 of them). Firstly is this possible and if so how do I go about this so that the user can select the site they require rather than having to key nthe site code?

Any help you can give would be greatly appreciated.

Thanks

Woody66

 

[PHV]

Create a parameters form, say frmParms, with the combobox showing the sites, say cboSites.
Then in your query replace the parameter like [Enter Site ID] with [Forms]![frmParms]![cboSites]
The parameter form must be open when the query is launched.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[woody66]

Hi

Thanks for the info that you sent but I cant seem to make it work!

I have created my frmparams form with the combo that I have called depot and put in the parameter as above (replacing your cbosites with my depot).

Have I done this correctly or am I missing something? By the way, I fogot to say that I am using access 97, does this mke ny difference?

Thanx

Woody