Filter problem - Access 2007

  • Thread starter Thread starter Moff
  • Start date Start date
M

Moff

Is somebody aware of a filter problem in Access 2007 forms ? My program works
fine with Access 2003 but not with Access 2007...
 
This is the code that is working in Access 2003 and
not in Access 2007. Can You helm me please ?

Private Sub Form_Open(Cancel As Integer)

Me.FilterOn = True
Me.Filter = "[actor_name] = '" & globalActorName & "'"

The result is supposed to show the form with only one record.
 
This code resolved the problem :

DoCmd.ApplyFilter , "[actor_name] = '" & globalActorName & "'"
 
Back
Top