Subform - autofill data from main form

[Kelly_D]

Hi

I have a database in access 2010 which includes a data form. This data form holds personal data about individuals such as name, address etc. A button leads from here to a subform where session detail can be entered. Both data and sessions are held on different tables but are linked by the persons name.



How can I get it to populate the Persons Name at the top of the subform when going from the main form? It works with existing people that I have already set up but when I do a new individual, because their name is not in the session table it will not bring their details through.

I hope this makes sense?

Any advice appreciated.

[June7]

The name shows on the main form, right? Why do you need to repeat it on the subform?

[Kelly_D]

Ahh think I've got confused.

I thought i'd got a subform opening in new window but looks as though I'd done it as a new form. The question then is: If I add it as a subform, how can I change my subform to open in a new window and not display on the main form? Or how to change the existing form which opens in a new window to be a subform?

The forms are quite involved so I need them separate.

I have no idea how to use VBA so simple answers work best please?!!

[June7]

Not understanding the issue. If you want a different subform then delete the current one and create a new one or change the SourceObject property of the existing subform container control.