Global Variable as Query Criteria

[ppkgoldengun]

I set a global variable based upon an employee logging into the system. I need to execute a form based upon a query. However, I need to limit the query results to the value of the global variable. How do I set the query criteria to the global variable so I only return the appropriate recordset?

Your help is appreciated.

 

[RoyVidar]

Hi!

A global variable can't be used directly in the query, but might be retrieved thru a public function.

[tt]Public Function GetMyGlobal() as <Your datatype>
GetMyGlobal = MyGlobal
End Function[/tt]

Then just enter GetMyGlobal() in the criteria field in the query.

HTH Roy-Vidar

 

[ppkgoldengun]

Excellent Thanks