Solved

How do you pass a Form variable to a Public Module

Posted on 2012-03-22
1
157 Views
Last Modified: 2012-03-22
If I have a Form called frmVolunteer and I have a field call txtFirstName how would I pass this to a Public Module call modLookupVol.  If the form stays open and I go to run module modLookupVol is it just a matter of referencing the variable Form!Forms!frmVolunteer!txtFirstName
0
Comment
Question by:upobDaPlaya
1 Comment
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 37754665
"How do you pass a Form variable to a Public Module"

You cannot pass a form variable to a Public *Module*

You can, however, pass a form variable to a Public *Variable*
Do something like this on a button on the form:
YourPublicVariable=YourFormVariable

If this is not what you wanted, then please take a moment to *First* explain, in detail, what your system is trying to do.

JeffCoachman
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question