D
D.Murray
I have a form that shows Batch Jobs by name. Connected to this is a subform
which shows unique Batch Job Name & Job Nbr combination records. The Batch
Job Name and Job Nbr are the primary keys for the table being sourced by the
subform. For Example, I have a form with Job Name of: Batch Job A and a sub
form which Shows Batch Job A, 12 Steps & Batch Job A 16 Steps. The Job Nbr is
hidden because its an internal number that ties back to source system. What
I would like to do is give the user the ability click on the batch Job name
in the sub form which will open form Batch Job Steps and display the steps
for that batch job, and while that form is up click on the next batch job
(duplicate) show the steps for that batch job. Back to my example, If the
user clicks on Batch Job A, 12 Steps it opens form Batch Job Steps and
displays the 12 steps then the uer clicks on Batch Job A 16 steps from the
subform and it shows form Batch job steps form with 16 steps.
Originally, I thought I would need to use the coding as provided by Allen
Browne, with additional code for a filter but I can't seem to make it work.
Any Ideas would be greatly appreciated!
which shows unique Batch Job Name & Job Nbr combination records. The Batch
Job Name and Job Nbr are the primary keys for the table being sourced by the
subform. For Example, I have a form with Job Name of: Batch Job A and a sub
form which Shows Batch Job A, 12 Steps & Batch Job A 16 Steps. The Job Nbr is
hidden because its an internal number that ties back to source system. What
I would like to do is give the user the ability click on the batch Job name
in the sub form which will open form Batch Job Steps and display the steps
for that batch job, and while that form is up click on the next batch job
(duplicate) show the steps for that batch job. Back to my example, If the
user clicks on Batch Job A, 12 Steps it opens form Batch Job Steps and
displays the 12 steps then the uer clicks on Batch Job A 16 steps from the
subform and it shows form Batch job steps form with 16 steps.
Originally, I thought I would need to use the coding as provided by Allen
Browne, with additional code for a filter but I can't seem to make it work.
Any Ideas would be greatly appreciated!