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]));