Selecting query criteria from a combo box.. Please help!!!

[Kwertyboy]

Hi all

I am trying to get my head around some of the more advanced “features” of access..

At the minute I am trying to change the criteria of a query from selecting a value from within a combo box.. I believe I have got the syntax correct, but I keep getting no results returned..

I am using:
[forms]![frmMovies]![combo2] as the criteria where frmMovies is the name of the form, and combo2 the name of the combo box.. I have set combo2’s source as the table containing the movie information “tblMovies”
Before you ask I am not trying to setup my own movie store, more apply the theory to a bigger DB that I am working on

Hopefully you can help, as I have now been scouring the forums for 2 days and am getting no where..

Thanks in advance

Noel

 

[MStef]

Your criteria is correct, it must be a mistake somewhere.
Check did you put criteria in regular column.

 

[neileg]

The value returned from the combo box will be from the bound column unless you specify another. As MStef suggests, make sure that you are matching like with like in your query.