View Full Version : Passing a value from a form to a report label


AndyS48UK
06-24-2002, 01:38 AM
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

Rich
06-24-2002, 06:04 AM
Use an unbound textbox not label

AndyS48UK
06-24-2002, 06:28 AM
Many Thanks.