Parameter from form to queries

[Erictsang]

Dear all

I wonder if anyone can advise me what was wrong as the input in the form does not activiate the query to get the result

I managed to get the combo box , run query button, and place the following in Query but it does not work

Appreciate your help

The SQL is

SELECT Hotel_T.G_Code, Hotel_T.O_Code, Hotel_T.PAIRNO, Hotel_T.Surname, Hotel_T.FirstNameFROM Hotel_T
WHERE (((Hotel_T.G_Code)=[Forms]![GroupSelector]![Grp_selector]) AND ((Hotel_T.O_Code)=[Forms]![GroupSelector]![Grp_selector]));

[aytee111]

Is the value "G0264" in the first column of your row source for the combobox? Is the bound column set to 1?

[pbaldy]

Your SQL has 2 criteria, comparing 2 different fields to the same combo. Is that appropriate?

[June7]

Do you use any lookups set on fields in table?

Continued from https://www.accessforums.net/showthread.php?t=67559

Apparently it wasn't working even when there was only 1 field in the criteria.

If you want multiple fields referencing same control, probably should use OR operator.

[Erictsang]

I have set the column to 1 and need only 1 criteria ( i try to make it column=2,still not workin

SELECT Hotel_T.G_Code, Hotel_T.PAIRNO, Hotel_T.Surname, Hotel_T.FirstName, Hotel_T.PAIRING, Hotel_T.HOTELNAME, Hotel_T.CHECKIN, Hotel_T.CHECKOUT, Hotel_T.NITE, Hotel_T.ROOM_TYPE, Hotel_T.REMARKS, Hotel_T.RM_PRICE, Hotel_T.TTL_PRICE, Hotel_T.PAY_MOD, Hotel_T.O_Code
FROM Hotel_T
WHERE (((Hotel_T.O_Code)=[Forms]![Form1]![Grp_selector]));

But it is not working
any idea ?

[Micron]

My guess:
The value in your combo is [grouping].[ID] because that is the first field in the SELECT order and you've bound column 1.
Yet your query WHERE clause is comparing O_Code to grouping.id. Without knowing what those fields contain, it's just a guess but the names suggest that there can't be a match.

[John_G]

What is the SQL behind the "Hotel Query" button (On Click event)?

Assuming the SQL you have posted is the query SQL, where are you calling it from? In order for the query to work, the form has to be open and has to have a value in the search combo box Grp_Selector.

[Erictsang]

Micron

so, how can I resolve it ?

Changed the order in Grouping ID to place in the last column
or change the Bound column to ??

Eric

[Erictsang]

Micon

I have amended it as follows:

SELECT Hotel_T.G_Code, Hotel_T.O_Code, Hotel_T.PAIRNO, Hotel_T.Surname, Hotel_T.FirstName, Hotel_T.PAIRING, Hotel_T.HOTELNAME, Hotel_T.CHECKIN, Hotel_T.CHECKOUT, Hotel_T.NITE, Hotel_T.ROOM_TYPE, Hotel_T.REMARKS, Hotel_T.RM_PRICE, Hotel_T.TTL_PRICE, Hotel_T.PAY_MOD
FROM Hotel_T
WHERE (((Hotel_T.G_Code)=[Forms]![Form1]![Grp_selector]));

I have set the column =1

Open the form1 and click run Query
the query does not work

[John_G]

I have set the column =1

Try setting it to 2 - O_Code is the second column in the Combo Box SQL.

[Erictsang]

John

I have solved it with changing the order of the O_Code and G_code
I make it

But i found that i have to refresh the queryy many time in order to get the result.
How can i do the auto refresh ?

Eric

[June7]

Should only have to refresh query once after selecting item in combobox.

Why not bind the query to a form and put the combobox on that same form? Review http://allenbrowne.com/ser-62.html

[Micron]

I have set the column =1
Open the form1 and click run Query
the query does not work

Sorry for not getting back here - have been busy with other projects. You are in good hands though.
The fix you used is fine; altering the query field left to right order or the bound column number is fine. Your choice.

[Erictsang]

Should only have to refresh query once after selecting item in combobox.

Why not bind the query to a form and put the combobox on that same form? Review http://allenbrowne.com/ser-62.html

As I have to query the result and convert it to excel, send this file to client. Hence, I made a form with this combo, and run the query on other.

If I bound the query as inform, can I do the same. Convert the result is not excel?

[June7]

What method are you using to export to Excel?

Form probably not best vehicle for that. Export query or a report bound to that query.