J
James
I would like my subform to auto populate information from a drop down box on
the main form. I am an advanced user so I know how to do most of the
building process. I just got stumped at the new information and auto
poulate stuff. Is there a way to copy information from a prior record when
it is selected from a drop down menu.
For example:
When I select Upper Body from the mainform's dropdown menu. Then all of the
exercises that are setup with upper body are displayed with the newest dated
information (i.e. If I add more reps or weight on my last workout I want
that information to populate when I select the same workout next time.),
while still keeping the prior record with the old information. I need to
track changes and then run reports on progress.
Each workout can contain more than one exercise and multiple of the same
exercise, typically with different reps and weights. Each exercise can be
in more than one workout.
the main form. I am an advanced user so I know how to do most of the
building process. I just got stumped at the new information and auto
poulate stuff. Is there a way to copy information from a prior record when
it is selected from a drop down menu.
For example:
When I select Upper Body from the mainform's dropdown menu. Then all of the
exercises that are setup with upper body are displayed with the newest dated
information (i.e. If I add more reps or weight on my last workout I want
that information to populate when I select the same workout next time.),
while still keeping the prior record with the old information. I need to
track changes and then run reports on progress.
Each workout can contain more than one exercise and multiple of the same
exercise, typically with different reps and weights. Each exercise can be
in more than one workout.