query with non-user parameter

[almoes]

Hi,

I have this SQL select:

SELECT Menu.ProductName, Menu.ProductID
FROM Menu WHERE (((Menu.CategoryID)=x));

Now I would like that x matches a 1 for field1, a 2 for field2 and so on...Is this possible somehow in combination with the 'Criteria' property of the fields?

thanxs!
alej

 

[Frink]

Hallo,

Where is your SQL? and where is your field1, field2?

- Frink

 

[almoes]

Sorry, the SQL is a query applied to a Combo box and my fields are in one of the tables of the db.

 

[Frink]

Hallo,

If you write the RowSource in code you should be able to do something:

.RowSource="SELECT Menu.ProductName, Menu.ProductID
FROM Menu WHERE (((Menu.CategoryID)=" & x & "));"

If you explain more, then so will I

- Frink

 

[almoes]

it's ok, you already helped me! Did not know it was possible to write direct SQL on the rowSource property and i dod not want to write 7 queries which would only differ on the 'x' value of the previous SQL statement.

thanxs!
alej