If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter on form open?
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" |
#2
|
|||
|
|||
Filter on form open?
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 |
#3
|
|||
|
|||
Filter on form open?
"papa jonah" wrote in message oups.com... 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" |
#4
|
|||
|
|||
Filter on form open?
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. |
#5
|
|||
|
|||
Filter on form open?
"papa jonah" wrote in message oups.com... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form won't open report from preview button | jwr | Using Forms | 5 | October 29th, 2005 04:53 PM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
ECHO Causing Problems | DS | General Discussion | 5 | May 17th, 2005 02:19 AM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Need query to separate 2 entry types in a table field | Jan Il | Running & Setting Up Queries | 31 | November 23rd, 2004 05:57 PM |