filter

  • Thread starter Thread starter RayNDM83
  • Start date Start date
R

RayNDM83

Hi,
Is there a way to replicate this vba command using the macros?
If Me.Filter = "" Then
MsgBox "Apply a filter to the form first."
Else
DoCmd.OpenReport "r_PullPkgCkOffSheet", acViewPreview, , Me.Filter
End If
End Sub
The reason why I'm asking is, when I make my dbase to ACCDE the vba code
does not work while macros do.
Thanks for the help.
Ray
 
Ray,

Yes, it is possible to do this same process in a macro.

But possibly the best solution to your problem would be to work out why the
VBA code is failing. First of all, make sure the .accde file is in a
Trusted Location.
 
Ray,

Ok. So when you say "the vba code does not work", do you mean *any* of the
VBA code, or just this specific procedure?

If you mean just this specific procedure, what actually happens? Error
message? Nothing at all happens? The report opens but is not filtered?
 
Back
Top