Sending the variable to a query as a criteria

  • Thread starter Thread starter SupperDuck
  • Start date Start date
S

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...
 
SupperDuck said:
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...
Click to expand...

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