Urgent! Three Cascading Combo Boxes.....

[birth19]

I have three different combo boxes and within this order.

Country = Combo54
Site_ID = Combo55
Site Survey Start Date = Combo80

I have correctly set up the first two that populate the information in the following combo box.

After making my selection in the last combo box (combo80). It asked for parameter values for different things and now its just doesn't pull any information within the text boxes within my form.



Can someone tell me if this code is correct. If not please advise!

Private Sub Combo80_AfterUpdate()Dim strwhere As String
strwhere = "[Country] =" & Me.Combo54 & " and [Site_ID] =" & Me.Combo55 & " and [Site Survey Start Date] =# " & Format(Me.Combo80, "yyyy-mm-dd") & "#"
Me.Filter = strwhere
Me.FilterOn = True

End Sub

[TheShabz]

what are the datatypes for the bound fields of Combo54 and 55