Change Query Object's Criteria via code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top