PreLoading fields for new record

[vfisher]

This is probably an easy thing to do but....

I am using Access 97. My users select a record and on that form is an edit and add button. When the Add button is clicked I open a new form in add mode, but I need to populate most of the fields from the current record, which is data from two tables. I've tried to use the default value from the current form to populate the fields on the new form. This seems to be a problem because the records are locked from the previous form so I can't write the new record. If I close the previous form, I don't have access to form fields any more.

Any help would be greatly appreciated.

Thanks,

 

[B827]

I think the easiest method here would be to use the OpenArgs from the Docmd.OpenForm action to pass the key inform to the create new form then use some code in the On Open property to populate the fields. Sandy