Passing a value from a form to a report label

AndyS48UK

Registered User.
Local time
Today, 05:15
Joined
Jun 22, 2002
Messages
59
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
 
Thanks

Many Thanks.
 

Users who are viewing this thread

Back
Top Bottom