Report Caption 1

[cneill]

Hi,

I have the following code in the onopen event
Me.TaxReports.Caption = "Summary Tax Report By House for Tax Year - " & "" & [Forms]![FrmSchemes]![TaxYear]

The TaxYear is a combo box, which is run from a query (QryTaxYears), the Bound Column is 1 (which is not visible on the form) Column 2 is visible on the form displaying the Tax year i.e. 2010-2011
Is there a way to pick up the Column 2 so that the caption displays
Summary Tax Report By House for Tax Year - 2010-2011?
Currently it displays
Summary Tax Report By House for Tax Year - 2 which is the Bound number from the autonumber field of the TblTaxYears
thanks

cneill

 

[MajP]

http://msdn.microsoft.com/en-us/library/aa224084(v=office.11).aspx

 

[cneill]

MajP
Fantastic Thank you
cneill