You can set values on other forms by simply referring to
the control on the other form.
For example, in the AfterUpdate of the FirstName field of the "entry" form, put code that looks something like this:
For example, in the AfterUpdate of the FirstName field of the "entry" form, put code that looks something like this:
Forms!frmOtherForm!txtFirstname =
Me.FirstName
It probably makes sense, however, to examine why you're
doing this and determine whether there's a better course of action. I
would only do this if form #2 were utilitarian in nature and I simply needed to
transfer the value for display purposes. If form #2 is bound, there are
likely better routes to take.
What is the nature of the two forms and why are you wanting
to update #2 from #1?
Tom Oakes
Personal PC Consultants, Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946 (C)
734.264.0911 (F)
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Richard
Sent: Tuesday, October 04, 2005 12:08 PM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] How to update a open form
am entering into another subform. When I change the data on the main
form, IE..Employee I would like for the 2nd form (not the sub form) to
change also. Is that possible?
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
| Microsoft access developer | Microsoft access help | Microsoft access database |
| Microsoft access training | Microsoft access training course | Microsoft access programming |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
