Query Builder

[Guest_imported]

Hi

I'm using the query builder in VB 6 and I'm a little stuck. I have selected the fields from two different tables that I require and placed the sort order, etc.

What I want to do is to only list values where an id field matches that of a variable on my form. In the criteria bit next to my field in the builder, I want to say something like "= MyVar" where MyVar is a variable declared on my form. I get the error "MyVar is not a part of the query".

Is there a way to list this? In Access you could set the criteria of a query to an object on your form such as a combo box so it only lists records that match that value.

Thanks for any help
Nora

 

[TimLarkin]

post the line/s your getting error on. Tim

Remember the KISS principle:
Keep It Simple, Stupid!

 

[sunaj]

Hi,

Post our code.
Your query should look somewhat like

Rst.open "SELECT * FROM TblMyTable WHERE MyField='" & MyVar & "'"


Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[Guest_imported]

Hi

It's OK thanks people, I've got it now!

Thanks again
Nora