How do I access data in a field in a form and place it in the current form?

Posted on 2003-12-01
Last Modified: 2012-05-04
Cannot remember how to open a form from the current form, obtain data from a field in that form, and place it in a field in the current form.  A basic question but I really need an answer.

Question by:bobcrewdson
LVL 22

Expert Comment

Comment Utility
Do you mean:



Accepted Solution

SNilsson earned 250 total points
Comment Utility
( where frmOther is the form to open)

From Current form:
Dim x as form

Set x = new frmOther

me.txtField.text = x.txtField.text


txtField is supposed to be a textbox in each form.

Hope that helps your memory :)


Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

728 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

14 Experts available now in Live!

Get 1:1 Help Now