Referring to a report control

[jwindon]

Is there a way to refer to a PREVIOUS record's control on a report?

 

[Rich]

Yes, look up the Tag property

 

[jwindon]

Thanks Rich.

 

[dudezzz]

Could someone elaborate on this please?

I have a similar situation to access a previous records value in the next record in my report. How can I use the "tag" property to get this done?

I looked at the Help on Tag but not able to understand how this can be used towards this situation.

Appreciate all the help.

thanks.

 

[Pat Hartman]

You need to put the current value of the control into its tag property.

Me.txtYourControl.tag = Me.txtYourControl

The key to doing this of course is that you need to use the existing .tag value before you replace it with the value from the current record.