How to use a combo box value as part of a query which is a report source?

[axman1000]

Hi! I'm new to this forum and new to MS Access too, so please bear with me



I have created a query which is the source of a report. The WHERE clause in the query is a value in the combo box, given as Combo.Text. The combo box's source is a column from a table and I'm not storing this value anywhere and had used the "Remember this value for future use" option which is provided when creating the combo box. When I select an option from the combo box, instead of opening the custom report, a popup which says prompts me for the parameter opens, and when I type the value, it generates the report, but I want it to generate it on the click of the button after I select the option from the combo box. How can I do this?

The query is as follows:

SELECT Table_1.Hotel_Name, Table_2.Name_of_Delegate, Table_2.Address, Table_2.City, Table_2.Center, Table_2.Spouse_Present, Table_2.No_of_Children, Table_2.No_of_Guests, Table_2.No_of_Rooms
FROM Table_1 INNER JOIN Table_2 ON Table_1.ID=Table_2.Hotel_of_Residence
WHERE Table_1.Hotel_Name=Form.Form1.Combo10;

[TheShabz]

The reason for the prompt is because it doesn't recognize Form.Form1.Combo10. This is the incorrect syntax. Replace that with Forms!Form1!Combo10 and it should pull from the combobox and do what you want.

[axman1000]

Thank you! That did get rid of the popup, but now, the reports are blank! At least, with the popup, the report would be generated, but now, all it opens is a blank report. What next?

[TheShabz]

First check to see if the combobox being referenced actually contains a value. If it does, run the query by itself to see if it pulls the correct data.

[axman1000]

Like I said, it's an unbound combo box and while creating it, I had used the Remember value for later use option, so what do I do now?

[axman1000]

Also, could you please help me with this question? Thanks!

[TheShabz]

The remember value option won't help in this case. if the form is not open and the combox doesn't have something in it, the query won't work right. So if you have the form open and there is a value in it, and it still doesn't display properly, keep the form open, and open the query and see if it works properly. If it does, then there is something wrong with the report. If it doesn't, then, outside of a typo, I have no idea what it could be.

I saw that other thread. Not sure I can help you with that one.

[axman1000]

Thank you for helping me this much! I'll redo and see what I can come up with Please do spread the word about the other question, if you know anyone who can help. Thanks!