Running a select query on combo box contents

[santastefano]

Good morning (at least in Italy)
I have used a combo box to retrieve data from a table and implemented the Access 2000 Developers Handbook not in list solution. Works perfectly but....
Later I want to use the contents of the combo box as the basis of a select query and the query does not return anything.
If I run the query with the form closed and enter the criteria it works.
Is it possible to base a select query on the contents of a combo box?
(The combo box has one bound column to return the required data for the user)
Thanks

 

[Remou]

Yes it is possible. An example of the SQL would look like:
[tt]SELECT tblPersons.PersonsKey, tblPersons.Forename, tblPersons.Surname
FROM tblPersons
WHERE (((tblPersons.PersonsKey)=[Forms]![frmForm]![cboCombo]))[/tt]

This example illustrates a two column combo where a name is shown to the user and a hidden bound column is used in the query.

 

[santastefano]

Thank you Remou, a good fix.