I am trying to filter a continuous view subform from a combobox. Should be easy enough, but I can't make it work. This is the code I have:
Private Sub Combo25_AfterUpdate()
DoCmd.ApplyFilter , "Me.txtStatus = '" & Me.Combo25 & "'"
I get no movement on the subform. I can apply similar language to the main form to filter by last name:
Private Sub Combo227_AfterUpdate()
DoCmd.ApplyFilter , "LastName = '" & Me.Combo227 & "'"
This works successfully. Any ideas why the subform filter is not working? The record sources are different; this shouldn't matter, right? The "allow filters" is set to "on" on the subform. Thanks for any help.