?
Solved

How do you pass a Form variable to a Public Module

Posted on 2012-03-22
1
Medium Priority
?
161 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Suggested Courses

764 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