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.