Filter on form open?

  • Thread starter Thread starter George
  • Start date Start date
G

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"
 
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
 
papa jonah said:
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
Click to expand...
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"
 
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.
 
papa jonah said:
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.
Click to expand...

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

Many thanks, indeed.

George
 
Back
Top