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 & "'"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Ribbon there has got to be an easier way 2
slow grid on form in Access 2007/Vista 1
Access 2003 --> Access 2007 code no longer working 6
2007 - form filtering problems 3
Access 2003 Form Breaking When Opened in Access 2007 1
Me.FilterOn problem - Access 2007 1
help with access 2007 , may be filter problem 2
Access 2003 Form no longer works in 2007 1

Back
Top