3 Tables
Main Table: Clients
Child Table: Skills
Child Table: HelpNeeded
All linked with field named ClientID
I have a form (Form1) which allows me to enter personal information for each client - one record per client.
From this screen, I would like to open a 2nd window in which I can update the Skills and HelpNeeded tables.
ON Form 1, if I add the Skills subform directly to the page, I can make all the changes without any difficulty.
However, I would like a separate window to open when I want to update the Skills Table (and the helpneeded table)
So, I made another form (Form 2) which displays the First Name & Last Name from the Client table - and has a subform which displays the Skills for that particular client (from the Table: Skills) .
IF I start on Form 1 - which has all the client personal information, and click the button to open Form 2 - everything looks OK, but the data displayed for the Client goes back to the 1st record in the table regardless of which record in Client I was viewing when I pressed the Open Form button to access Form2
How can I maintain the current record when the 2nd form is opened?
Oh..and by the way.....I"m hoping I can do this without having to write my own code. I am VERY VERY new to Access and am using Wizards and buttons and all kinds of user friendly devices.
If I have to code it myself - I guess I'll need you to point me to a resource to use so that I can figure out how!
Main Table: Clients
Child Table: Skills
Child Table: HelpNeeded
All linked with field named ClientID
I have a form (Form1) which allows me to enter personal information for each client - one record per client.
From this screen, I would like to open a 2nd window in which I can update the Skills and HelpNeeded tables.
ON Form 1, if I add the Skills subform directly to the page, I can make all the changes without any difficulty.
However, I would like a separate window to open when I want to update the Skills Table (and the helpneeded table)
So, I made another form (Form 2) which displays the First Name & Last Name from the Client table - and has a subform which displays the Skills for that particular client (from the Table: Skills) .
IF I start on Form 1 - which has all the client personal information, and click the button to open Form 2 - everything looks OK, but the data displayed for the Client goes back to the 1st record in the table regardless of which record in Client I was viewing when I pressed the Open Form button to access Form2
How can I maintain the current record when the 2nd form is opened?
Oh..and by the way.....I"m hoping I can do this without having to write my own code. I am VERY VERY new to Access and am using Wizards and buttons and all kinds of user friendly devices.
If I have to code it myself - I guess I'll need you to point me to a resource to use so that I can figure out how!
Last edited: