I use two different list boxes to choose data between two different time periods. The list boxes shows three columns: month week and Year. I would like to post the beginning and ending time periods on the report header but am having trouble getting the column info (in the list box) to appear on the report header. Here is what I have tried so far.

=[Forms]![Menu]![List27]![Year]

My results have been error messages.

Thanks in advance.

The way to reference a column from a listbox or combobox is with the column property.

=[Forms]![Menu]![List27].Column(2)

The columns are a zero based array, so the third column is .Column(2) and the first is .Column(0).