A simple question I think but I'm baffled...
...I have three option buttons in a group on a form and, depending on the button selected I want to pass a caption to a label on a form.
The report takes its detail from a query.
If the option button value is 1 then I want to pass "GPB" as the caption. 2="USD" etc
I've tried (from the OK_Click event attached to the command button on the form) to embed this into the "if" statement that opens the report...
reports("rptOrderAc").controls.label("lblCurr").caption="GBP"
but to no effect.
Can anyone tell me if I'm even going in the right direction?!
Thanks
...I have three option buttons in a group on a form and, depending on the button selected I want to pass a caption to a label on a form.
The report takes its detail from a query.
If the option button value is 1 then I want to pass "GPB" as the caption. 2="USD" etc
I've tried (from the OK_Click event attached to the command button on the form) to embed this into the "if" statement that opens the report...
reports("rptOrderAc").controls.label("lblCurr").caption="GBP"
but to no effect.
Can anyone tell me if I'm even going in the right direction?!
Thanks