Hi

How can I pass the value to query?

Do I need to set the recordset...or something..

If you have any sample, could you send it to me??

Thanks

It depends on where the value is. If it is in a control on an open form you can use:

Select ...
From ...
Where YourFld = Forms!YourFormName!YourControlName;

Thanks for reply Pat Hartman!!

But ..I put the code to form or query??

I just Use NUMBER to store the value.

DIM NUMBER as integer

I try to put [FORMS]![form1]![NUMBER]
to the query..but nothing come out...

Thanks for help 1st