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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass variable from form to Query ... 6
how do you convert a string form name to a "form" variable 2
Subform opens before main form 8
Variable in module to reference form 6
Pass a filter variable from one form to another 3
Pass variable from one form to another? 3
Variable Pass to new record 1
VBA: How can I use a string variable as autofilter criteria? 4

Top