Open a form filtered from Calendar Control 9.0

[Axeloz]

Hi,

I'v created a form with a calendar control !
I chose a date on the active x calendar(stored in CtlActiveX2 and in a global variable "day_date" in Module1)and click "OK". The button "OK" bind to a macro
wich open the form "users_date".
But now, I cant filter the query bind to this new form.
How can I filter ?

TIA

Frédéric

 

[Robert Dunstan]

Hi

What you need to do is to create a function that returns the value of your global variable...

Public Function GetVar() as String or whatever
GetVar = yourGlobalVariable
End Function

Then in your query set the criteria in field you want to filter on to:
=GetVar()

HTH
Rob