Duplicate a Record with a Subform

[sondriven]

I have a simple Form with a subform. I inserted a button using the wizard to duplicate the record.

It works but when I go and change something in the new record all the information in the subform disappears. Can anyone shed some light on this?

Thanks.

 

[jimbrooking]

The duplicate record button duplicates the record on the main (parent) form, right?

And the child (sub) form is linked to the parent form perhaps using a foreign key in the child form?

If this is the case, then when you type something in the duplicated record, I expect a new index, or key value is generated for the master form, and the subform has no corresponding record to link to (display), so it goes blank.

HTH,
Jim

 

[sondriven]

I understand that the form and subform are linked but is there a way to do this?

 

[jimbrooking]

I expect it's already done, esp. if you put the subform in the main form with a wizard. With the subform selected, look at the properties' Data tab and you ought to see the parent=child relationship.

I don't think the solution is to unlink the subform, but instead, to find a way to populate it as soon as the duplicate record is created. Maybe bring up a pop-up form as soon as the new record is created.

 

[sondriven]

Im sorry, but now im a little lost. Only been working with Access for about 4 months. Could you explain what steps Ill need to do to accomplish this? Much appreciated.