filter value in a combo box

[dada]

good day to all! here is the scene, i have a two combo box namely, comboFrom and comboTo.. they have the same values coming from a table named tblMonth. so it would be like, January, February, ...... December.. what i want to do is when i select February on my comboFrom, the values that can be selected only in the comboTo would be starting on March onwards, since February is the starting date, comboTo will only have March - December selection.. i hope i made it clear.. and Thanks in advance!

[RuralGuy]

What is the RowSource of your ComboBoxTo?

[maximus]

I this is what I have done. i have a table with the names on the month and a ID column.

name of my Table= tblMonth
it has two fields= {ID, mnth}

I have two combox on my form one Combo0 the Other Combo2.

In the Combo0 after Update event I use this code:

Private Sub Combo0_AfterUpdate()
Dim strSQL As String

If Me.Combo0 = 12 Then
strSQL = "Select * from tblmonth Where ID =" & Me.Combo0
Else
strSQL = "Select * from tblmonth Where ID >" & Me.Combo0
End If

Me.Combo2.RowSource = strSQL
Me.Combo2.Requery

End Sub


attached is a sample. Check Form4

[ssanfu]

This line

strSQL = "Select * from tblmonth Where ID =" & Me.Combo0

should be:

strSQL = "Select * from tblmonth Where ID>0"


*** Or see attached mdb


HTH
------
Steve
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)