I have two Windows 7 PCs that when the user clicks on the filter lookup (binoculars) button located on a form, they get error 70 - permission denied. XP PCs do not have this problem and other Windows 7 PC do not have this problem. I found out that if I comment out the Send Keys line in the code, the user does not get the error 70 problem........but when the Find window box opens up, the default search is set to search "Whole Field" instead of "Any part of the field", which is what the sendkeys line was supposed to do in the first place. Not sure how to over come this.........
Private Sub FilterByLookup_Click()
On Error GoTo Err_FilterByLookup_Click
MsgBox "Error No: " & err.Number _
& " in " & Me.ActiveControl.Name & " procedure; " _
& "Description: " & err.Description