Filter problem - Access 2007

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...
 
M

Moff

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.
 
M

Moff

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

Editing problem 1
Help creating a search form in Access XP 0
access 2007 macro not working in access 2010/2013/2016 0
Access 2003 --> Access 2007 code no longer working 6
Access 2016 docmd sendobject crash after March update 0
slow grid on form in Access 2007/Vista 1
Keeping to ms office 97 pro 0
Master - Child links not working in 2007 0

Top