Accessing a Report element in VBA

[DavidArchibald]

I'm a newbie to Access VBA so apologies in advance if this is a bit of a dumb question.

I have a value in a text field in a report - InvoiceNo and I want to use this to do some backend tidying up with VBA when the report is closed.

How do I reference the variable?

The Report name is [Print Invoice] and the text box (which gets its value from an underlying query) is called Invoice No.

I want to do something along the lines of:

x = Reports-collections.reportname.object.value

if that makes sense.

Thanks

 

[KenReay]

Hi

You are more or less there

Reports("Print Invoice&quot![Invoice No]

However [Invoice No] is only in scope in the section to which it belongs (eg say detail section)

Regards
Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use