Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / May 2008

Tip: Looking for answers? Try searching our database.

opening a form and using data from another form to fill fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
LiquidWrench - 20 May 2008 03:51 GMT
I have 2 tables in a database 1 called Contacts the other called 7 Step
The relationship is a one to one. There is a form called Contact Details.
This form along with the Contacts table was part of the Contacts Template
that I downloaded.
I placed a button on the Contact Details Form, which is created by a query,
that will open a form called 7 Step. I want to be able to open this form and
enter information into the 7 Step form directly related to the current record
in the Contact Details Form.  Currently the 7 Step form is also created by a
query.  Simply if the current record on Contact Details is "John Doe" I want
to be able to open the 7 Step form and hav that name visible as well as
update the record in the 7 Step table. Please help I have tried a few
different suggestions on here but the results are not quite the proper ones
PJFry - 20 May 2008 05:08 GMT
On the On Load event of the form 7 Step try this:

Me.[Field to hold 'John Doe'] = Forms![Contract Details]![Field that holds
'John Doe']

PJ

> I have 2 tables in a database 1 called Contacts the other called 7 Step
> The relationship is a one to one. There is a form called Contact Details.
[quoted text clipped - 8 lines]
> update the record in the 7 Step table. Please help I have tried a few
> different suggestions on here but the results are not quite the proper ones
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.