asked on
Using a global variable as criteria in query grid
I am trying to set a global variable from a form module...then reference the global variable in the criteria of a query grid. The attached file lays out the 3 steps. I am failing miserable. Your expert help would be appreciated.
Microsoft DevelopmentMicrosoft Access
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
That worked...Thanks
Option Compare Database
Global FilterFacility As String
Public Function GetFilterFacility() As Variant
GetFilterFacility = FilterFacility
End Function
Option Compare Database
Global FilterFacility As String
Public Function GetFilterFacility() As Variant
GetFilterFacility = FilterFacility
End Function
Exactly!
So, what version of Access are you using?
So, what version of Access are you using?
What version are you using?
mx