Drop Down Combo Box on Report - tried using form..

[abradford]

I have this query: qryBSMRDb

SELECT *
FROM qryBSMRDGSa
WHERE (((qryBSMRDGSa.Response)=3) AND ((qryBSMRDGSa.RD)=[Enter RD]));


Which calls another query: qryBSMRDa

SELECT RD, BSMNum, BSMName,'BSMMedSup' AS Instance, BSMMedSupCom AS InsatnceB, BSMMedSup AS Response FROM [BSMRDGS]
UNION ALL SELECT RD, BSMNum, BSMName, 'BSMMMA', BSMMMACOM, BSMMMA FROM [BSMRDGS]
UNION ALL SELECT RD, BSMNum, BSMName, 'BSMPDP', BSMPDPCOM, BSMPDP FROM [BSMRDGS]
...
...

I am trying to make the "[Enter RD]" parameter from the first qry mentioned above, a drop down selection combo box parameter.

I have tried the following link, by creating a separate table with the criteria selections:

http://www.fontstuff.com/access/acctut08.htm

but I am having trouble when it comes to section 2.2 - 2.3. I think because when I use the Build function the criteria, I am calling it form a Query, not a table, like their "staff" table??? Is there another way to accomplish the dropdown?

Thanks

 

[Remou]

In the link you posted, the build function is being used in the query design screen to ensure that the syntax is correct. You can type directly onto the criteria line:

Forms![NameOfFormWithComboBox]![NameOfComboControl]

However, I think you may have a different problem, if the build is not working for you.

 

[abradford]

When I Enter [Forms]![frmRD]![ComboRD] into the criteria of my RD column in my first query, I get a "Enter Parameter Value" Box with [Forms]![frmRD]![ComboRD] displayed above the text box...

So something is wrong here...?

 

[abradford]

so here is what I have for qryBSMRDb:

SELECT *
FROM qryBSMRDGSa
WHERE (((qryBSMRDGSa.Response)=3) AND ((qryBSMRDGSa.RD)=[Forms]![frmRD]![ComboRD]));

and when i test i do not get the dropdown criteria box...

 

[Remou]

Do you have a form called frmRD which has a combo box ComboRD and a button to call qryBSMRDb?

 

[abradford]

Sorry for the double post, I am new. I was able to get the query to open using the drop down criteria form, now, the question and final destination of mine, is how do I have the Dropdown criteria open a report based on the query?

 

[Remou]

This thread continues at:
Drop down combo box to open Report...tried tutorial no luck
thread703-1296794