How do I get the year I select to show? (Access 2000)

Topic

New Reply

I have a report that prints out and shows the year I selected, but I want to put that year in the Title of my report. I have the Title referenced as =[Forms]![frmSelectCategories]![cmbSelectSchoolYear]

When I preview my report, I get the SchoolYearID instead of the SchoolYear. I have the combo box showing the SchoolYear when I select the dropdown. But for some reason my Title is refering to the primary key (SchoolYearID) instead of the SchoolYear I selected (2004/2005).

Reply | Quote

Replies

Your combo box probably has more than one column. If the first column is SchoolYearID, and the second column is SchoolYear, you can use

=[Forms]![frmSelectCategories]![cmbSelectSchoolYear].[Column](1)

(Columns are numbered starting at 0, so Column(1) is the second column)

Reply | Quote

Works great now! Thanks, Hans.

Reply | Quote

Works great now! Thanks, Hans.

Reply | Quote

Your combo box probably has more than one column. If the first column is SchoolYearID, and the second column is SchoolYear, you can use

=[Forms]![frmSelectCategories]![cmbSelectSchoolYear].[Column](1)

(Columns are numbered starting at 0, so Column(1) is the second column)

Reply | Quote