Pass a variable from a form to a sheet?

C

chilidog1000

I have a variable on a form that I need to pass to a sheet for a query.
It appears that I see the data on the selection (Treeview) and have
set the variable to "Public", but when it passes to the sub routine
that value is now empty?

Confused? Any help is greatly appreciated. Thanks in advance
 
T

Trey Davis

You must explicitly declare your varialbes. Put in the following line:

Option Explicit

HTH

Trey Davis
Microsoft Access MVP
 
Top