M
mike@sepomo.com
Guest
Hi
We use access to generate billing reports, and have come across a mysterious problem with prompting for field values.
We run a main report, with 2 sub reports. The main report needs a client id , which we can input either prompted via the underlying query, or as a WHERE condition in a macro that opens the report. The sub reports need the same client id. To date, I type it in 3 times :$ which seems unnecessary.
So I've tried linking the primary and secondary fields so that the sub reports pick up the client id. But Access prompts me to input a field, and the name of the field is the table name where the sub report is picking the client id from.
I cannot see why it does this. Does anyone have any ideas ?
Many thanks in advance
Mike Beattie.
We use access to generate billing reports, and have come across a mysterious problem with prompting for field values.
We run a main report, with 2 sub reports. The main report needs a client id , which we can input either prompted via the underlying query, or as a WHERE condition in a macro that opens the report. The sub reports need the same client id. To date, I type it in 3 times :$ which seems unnecessary.
So I've tried linking the primary and secondary fields so that the sub reports pick up the client id. But Access prompts me to input a field, and the name of the field is the table name where the sub report is picking the client id from.
I cannot see why it does this. Does anyone have any ideas ?
Many thanks in advance
Mike Beattie.
