Trying to filter a form by VBA

  • Thread starter Thread starter JohnC
  • Start date Start date
J

JohnC

I am trying to filter a form from an unbound combo box on that form

Combo68 is the combo box having a drop down of months ie Jan, Feb,
Mar....
frm COMPLAINTS is the name of form
month is a field having values Jan, Feb, Mar....


..............................................................
Private Sub Combo68_AfterUpdate()
Dim xXy As string

xXy = [Combo68].Value


DoCmd.OpenForm "frm COMPLAINTS", , , Month = xXy
End Sub


I know I can do the same thing many other ways but would like to know
what is wrong with this

John C
 
John,
In addition to Peter's comment, I'd avoid using the word 'Month' as a field
name as it is also the name of an Access function.
 
Back
Top