Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Passing a global variable to a query 1
- Thread starter xhuck28x
- Start date
-
1
- #2
Hi!
Rather use a userdefined function. In a module (not a forms module), but you could place it where you've declared your public variable:
[tt]Public Function GetgPONumber() as <datatype>
GetgPONumber=gPONumber
End Function[/tt]
Then
"WHERE PurchaseOrderLineItems.PONumber=GetgPONumber()"
should work in the SQL view of the QBE. Substitute <datatype> with datatype of gPONumber.
HTH Roy-Vidar
Rather use a userdefined function. In a module (not a forms module), but you could place it where you've declared your public variable:
[tt]Public Function GetgPONumber() as <datatype>
GetgPONumber=gPONumber
End Function[/tt]
Then
"WHERE PurchaseOrderLineItems.PONumber=GetgPONumber()"
should work in the SQL view of the QBE. Substitute <datatype> with datatype of gPONumber.
HTH Roy-Vidar
- Thread starter
- #3
- Status
Similar threads
- Question
- Locked
- Question