Passing variables from one form to another?

C

CD Tom

I'm trying to pass two variables from one form to another
and can't seem to find a way. I've tried setting the
variable as public but that only seem to work in the
current form. Any help would be appreciated.

CD Tom
 
A

Aaron

You can hide the first form,then show the second form,in the second form,you
can directly quote the variables from the first form.....
then in the second form, add below code in close events,
docmd.close acform "first form"

Aaron _~@
Yang _`\<,_
? (*)/&(*)
~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
 

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

using a variable to filter 3
Access 2007 Verses 2003 - passing of variables. 2
Passing a variable from a form to a query (where criteria)? 4
I need a Form button to open and pass two variable values to a re 2
Referencing a form name 5
query value subform 3
Passing an array parameter to forms Open Event 6
Dynamically moving from one form to another 4

Top