Parameter Help!

[nikgupta]

I've created a query which looks like this:



Field Last Name Nationality
Table Table 1 Table 1
Criteria [Last Name:]

It worked fine as a query however in order to make it easier to use I tried to make a drop down list for the parameter (last name by using a form. After having created a form with a combo using the last name field from table 1 and a button on the form that ran the query, I used the builder to create an expression and deleted the parameter. It looks like this:

Field Last Name Nationality
Table Table 1 Table 1
Criteria [Forms]![Form1]![Combo11]

However after selecting a value from the combo and running the query on the form, both the Last Name and Nationality Column are empty. I have no idea what I'm doing wrong.

[nikgupta]

*([Last Name:]) not (Last Name

[nikgupta]

And just to confirm the criteria on the nationality column is empty on the 2nd 'diagram'