Sending the variable to a query as a criteria

[SupperDuck]

Hello,

I can send a value as a criteria to a specific query if it is a text of a
textbox, combobax, label etc.

But, i wonder if i can send a variable to a guery...

I mean, such as...

dim a as integer

a= me.texbox3.value

requery xxx...

And in xxx, there should be column, for ex. xyz that has the criteria a..

But it does not work How can i do it?

thanks...

 

[Rick Brandt]

Hello,

I can send a value as a criteria to a specific query if it is a text
of a textbox, combobax, label etc.

But, i wonder if i can send a variable to a guery...

Create a user defined function that returns the value of the variable and use
the function in the query.