How to make a cascading combobox with multiple values? (1 Viewer)

[cheberdy]

I have a form with two combo boxes where I set the start month in the first and the end month in the second. It then filters me all the months in between. I would like to have an additional combo box for all the days of the months that were previously selected. Can I do this with a query where I set a criterion? What would the criterion look like?

 

[Gasman]

Month(datefield) >= than first combo and Month(datefield) <= second combo

Might need to include year, if you span across into the next/previous year?

 

[theDBguy]

When you said all the "days," did you mean all the "dates?"

 

[Josef P.]

select ... from ... where DateField between dateserial(YearValue, [FirstMonth], 1) and dateserial(YearValue, [LastMonth] + 1, 0)

... enables the use of an index.

 

[cheberdy]

Month(datefield) >= than first combo and Month(datefield) <= second combo

Might need to include year, if you span across into the next/previous year?

SELECT TimeSplit.Day, TimeSplit.Month
FROM TimeSplit
WHERE (((Timesplit.Month)=[Forms]![Timesort]!Month Between [cboStart] And [cboEnd]));

Timesplit is the source query. Timesort is the form and cboStart and cboEnd are the combo boxes. However, when I do it this way, it does not recognize cboStart and cboEnd.

 

[Josef P.]

SELECT TimeSplit.Day, TimeSplit.Month
FROM TimeSplit
WHERE Timesplit.Month Between [cboStart] And [cboEnd]

If the data source is used in a combobox in the same form with the 2 comboboxes, the form reference is not needed.

 

[cheberdy]

SELECT TimeSplit.Day, TimeSplit.Month
FROM TimeSplit
WHERE Timesplit.Month Between [cboStart] And [cboEnd]

If the data source is used in a combobox in the same form with the 2 comboboxes, the form reference is not needed.

It still does not recognize the combo boxes

 

[Josef P.]

Do you execute Combobox.Requery after a value changed?

private sub cboStart_AfterUpdate()
    me.Your3rdComboxWithAboveSql.Requery
end Sub
private sub cboEnd_AfterUpdate()
    me.Your3rdComboxWithAboveSql.Requery
end Sub

 

[Gasman]

It still does not recognize the combo boxes

I would always concatenate the the combo values?