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

  • Thread starter Thread starter LiquidWrench
  • Start date Start date
L

LiquidWrench

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
 
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
 
Back
Top