Subform - to be filtered by Year Combo Box and then Month Combo Box

[crimedog]

I have a Form - Based on Rep Name.
Under that is a Subform Based on Sales
The Rep Name is the first filter for Subform, Then there is a ComboBox on the Subform Based on Year (this is next filter)


And lastly, there is a ComboBox on Subform Based on Month - this is the last filter.

I have it working for Rep + Year, but when I Change the ComdoBox Month - It asks again for year (even though it is selected int he original comboBox Year)

Tried to upload Example, but the size was too big...

[June7]

Did you run Compact & Repair then zip the file? 2mb zip file allowed. If still too large, can upload to fileshare site such as Box.com and post link to file. Identify form involved.

[crimedog]

Here is the file

[crimedog]

Okay - I have gotten rid of the error message and set the comboboxes to update correctly (with correct syntax)

froms!Maiform!Subform1.form.RecordSource

Now I need the Subform to filter based on Cbo Month & Cbo Year

See attached (zipped file)

I am guessing it is simple fix.

[June7]

Do you want both criteria to be required or do you want to allow one or the other alone?

Suggest you change TabOrder for each combobox so CboYear is 0 and CboMonth is 1.

If you want to require both criteria, consider:

Set CboMonth Enabled property to No.


Private Sub CboYear_GotFocus()
Me.FilterOn = False
Me.CboMonth.Enabled = False
End Sub

Private Sub CboYear_AfterUpdate()
Me.CboMonth.Requery
Me.CboMonth.Enabled = True
End Sub

Private Sub CboMonth_AfterUpdate()
Me.Filter = "[OrderYear]=" & Me.CboYear & " AND [OrderMonth]=" & Me.CboMonth
Me.FilterOn = True
End Sub

[crimedog]

Great! Works just like I had imagined it should