Filter on form open?

[George]

Hi!
I am struggling with Access!
Can't seem to get hold of the concepts.
I have created a table, and an associated form.
With the form is a filter.
I want to have the filter set automatically, when the form is
opened.
How?
(The filter has to be set every time on opening.)

Access 2000, Windows XP

George
g4egg, who remembers "PRESS PLAY ON TAPE #1"

 

[papa jonah]

Insert this into your "on load" event:
Me.FilterOn = True
and have your filter criteria listed in the data tab of the form
properties.

HTH
Papa

 

[George]

Insert this into your "on load" event:
Me.FilterOn = True
and have your filter criteria listed in the data tab of the form
properties.

HTH
Papa

There is no "on load" in the properties, and the data tab is all greyed out.
???

George
g4egg, who remembers "PRESS PLAY ON TAPE #1"

 

[papa jonah]

Go into your form's design view. Click on the square in the upper left
hand corner (the square should fill in with a solid black square) and
open the properties pane.

 

[George]

Go into your form's design view. Click on the square in the upper left
hand corner (the square should fill in with a solid black square) and
open the properties pane.

Yes!
It worked!
(Hadn't seen that properties before. Thought there was something that I had
missed)

Many thanks, indeed.

George