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 wrote:
> 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.


-- 
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com