Convert time stamp Now() to Fiscal Year

[June7]

Maybe you want cascading (dependent) comboboxes. Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the 3 on comboboxes in the Access Forms: Control Basics section.

[ajcke]

After watching the first combo box video I think I realized that my assessments should probably be in their own table.

I'm still not sure how to get the report button to filter the data based on the dates and assessment combo box together.

[June7]

You want button to open report with filter criteria input on the form? Refer to controls on form as input parameters. Options:

1. parameterized query

2. WHERE CONDITION argument of DoCmd.OpenReport. If both values will always be provided, simply:
DoCmd.OpenReport "report name", , , "fieldname1=" & Me.textbox1 & " AND fieldname2='" & Me.textbox2 & "'"
If fields are not text type, remove the apostrophe delimiters, date/type uses # delimiter.