Bound controls not displaying Default data on form

[murpl]

<groan> I have two forms that use the same table. The table is an employee record, (name, address, phone, etc) and Form1 is used to gather this info. Also on Form1 I've created a text box control that opens Form2 on focus, if the field is null, which is used to gather information for a &quot;contact&quot; person in case of emergency, etc. This data is also stored in appropriate collumns on the same table. Everything seems to work hunky-dorey except in the properties for the controls on Form2 I've tried to set the default value to reflect the same info entered on Form1 which the user can either accept or edit. ie: since the contact person is usually a spouse or someone living at the same address then the address is probably the same. I've tried

=[Address]

and

=Forms![EmployeeInfo]![Address]

etc to no avail. The controls come up blank except the ones with the default value set (text) from the field properties in the table.
Am I doing this wrong? Should I have more tables? Less forms? Should Form2 be a subform of Form1? HELP!
Btw, Form1 is modal and Form2 is popup modal.

Thanks,
Mike

 

[DougP]

Try saving the record before you open form2.
using Docmd.goto record ..... DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[murpl]

Thanks, Doug. I'll give that a try... er, I have been attempting to do that but &quot;gotorecord&quot;? I've been using the DoCmd.save method with no success. The data is saved but still not being displayed in Form2.
Thanks for the response!

Mike