Solved

Access one Form Element through another Form using VBA

Posted on 2011-02-18
1
529 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

760 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

21 Experts available now in Live!

Get 1:1 Help Now