Pass a variable from a form to a sheet?

  • Thread starter Thread starter chilidog1000
  • Start date Start date
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
 
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

how do you convert a string form name to a "form" variable 2
Pass variable from form to Query ... 6
Scope issue? Variables passed from form to report with OpenArgs 6
Dynamically moving from one form to another 4
Variable in module to reference form 6
Passing check box controls to a function 2
Use the value of a parameter passed to a subroutine to update a re 4
Can You Use SQL Max() Function Based on Variable From Form 1

Back
Top