Change Query Object's Criteria via code

J

Joel

Let me try again:

TIA very much:

Is it possible to change and existing Query Object's criteria via VB code??

If so how might it be done?

Thanks again,

Joel
 
J

Joel

WOW found information in earlier thread from Norm "VBA verbal..."

This is something I have been looking for. Thanks Norm. But I have a
problem...

Anyone able to help?? TIA

I set up function in a module for my database

Function testjbl()
testjbl = variablename
End Function

I have a button on a form that on click
variablename=7

In a query I set criteria to testjbl() (Saw function in function list in
Build)

when I run it ...Function not recognized...

Any help??? Does it matter where the function code is or how to set the
value for variablename??

Thanks so much anyone

Joel
 
Top