Variables 1

[gary1]

How do I create a variable that I can use in 2 different queries. Rather than type the same dates twice I would like to store then in a variable then use them as I need them.

Any help would be much appreciated.

 

[PaulF]

Create a Public Variable in a module

i.e.

Public strVar as String

Store the Value to the variable in your code, then when you want to use it in your query's Criteria Row, call it from a Public Function

Ex: of Public Function

Public Function ReturnVar()
ReturnVar = strVar
End Function


Use this for the Query's Criteria Row

ReturnVar()


PaulF

 

[MattBegg]

Thanks PaulF

Worked a treat and helped out inn another area too Regards

Matt

matt@begg-uk.co.uk

 

[gary1]

Thanks Paul worked a treat