Solved

Access one Form Element through another Form using VBA

Posted on 2011-02-18
1
530 Views
Last Modified: 2012-06-27
I have two forms in my VBA application, i want to access one form element values in another form, whats the way to do

Ex:
Login Form- User Name, Password
Customers List Form- Name, User Name, Password

I want to access the 'Login Form' values to be accssed using ' Customers List Form'
0
Comment
Question by:srikanthv2322
1 Comment
 
LVL 22

Accepted Solution

by:
rspahitz earned 500 total points
ID: 34930224
you should be able to reference it directly by the control on the form name.

For example:

Me.Password.Text = frmLogin.Password.Text

Assuming that you are currently in the customer form...aka Me...and frmLogin is the Login Form, and the textbox with the password is called Password
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now