Trying to auto apply form filter upon loading

[dcavaiani]

Private Sub Form_Load()
Forms(0).ServerFilterByForm = True
End Sub

This 2002 code is producing an error ?

 

[pbaldy]

I'm not familiar with that method. You could try:

Me.Filter = "FieldName = Value"
Me.FilterOn = True

or open with this:

http://www.baldyweb.com/wherecondition.htm

 

[Hagridore]

I have added a button onto my main database dashboard to open a search form in "Filter by Form" mode. I used the macro builder to set it up. It appears to be working very well. I am not able to add some buttons onto the form and have them run the filter process, but the "Toggle Filters" button on the Home ribbon does the job.

Here's my macro: