Criteria Query Combo Box

[bgcogen]

Hi.
I have a report that is based on a criteria query. The user is asked for machine part and site. Right now the user has to manually type in the site and then the machine part required for the report.

Is there anyway for the user to be presented with a combo-box pulldown menu instead of typing out the criteria as there are only two different sites to choose from????

Thanks for any help anyone can give on this regard.

D

 

[Hayley Baxter]

You could create a pop up form with your combo box then have a query to look to the form ie forms!yourformname!yourcomboboxname. On your form use an Ok and cancel button where the ok button will open the report based on your selection(s) in the combo. Base your report on the query.

If you're not sure I can send you something to look at.

Hay

 

[bgcogen]

Hi.

I created a popup form called Site_combo an inserted a combox of all the sites called SiteA onto the form.

Then in the Query in the criteria field under Sites I entered:
Forms!Site_combo!SiteA. When I tried to run the Query it changed the above expression to: [Forms!][Site_combo!][SiteA]

And didn't work.

Any suggestions?????

Thanks,
D

 

[Hayley Baxter]

It should look like [Forms]![Site_Combo]![SiteA]

Is site_Combo the name of your form? the order it should be in is forms, your form name then your combobox name and the criteria should be as above. I can email you an example if you prefer?

Hay

 

[bgcogen]

Hi.
Ya, I entered it as you said:
[Forms]![Site_combo]![SiteA]

But instead of the pop-up form I get a dialog box saying:

Enter Parameter Value Forms!Site_combo!SiteA

Any ideas???


If you could send me an example it would be BRILLIANT!

Thanks for your help,
D


dmungovan@bge.ie

 

[NSTLouis]

I am having exactly this same problem. Perhaps I could get a copy of the samples too? Did your problem ever get resolved?

clanriordan@juno.com

 

[Iwra]

Hi

Hayley posted a sample in this thread that I used myself. Not sure if this helps you

http://www.access-programmers.co.uk...3252&highlight=open+a+report+from+a+combo+box

 

[NSTLouis]

Thanks - that was immensely helpful. I've been stuck on this problem for a month and it is great to move forward again.