Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
apply form filter on open form
0 views
Skip to first unread message
Smoki
Aug 13, 2008, 5:15:01 AM8/13/08
to
Hi,
I created form with fields from different tables. It is a simple form, it is
not based on query. Form shows equipment from different location. But I to
list just from specific locations, not all of them. Locations are in one
table. I have a filter on my form, where I choose locations.
But, how to apply filter on open (I want to see selected equipment from
specific location when I open form, not after click on command button, or
something like that)?!
I created form with fields from different tables. It is a simple form, it is
not based on query. Form shows equipment from different location. But I to
list just from specific locations, not all of them. Locations are in one
table. I have a filter on my form, where I choose locations.
But, how to apply filter on open (I want to see selected equipment from
specific location when I open form, not after click on command button, or
something like that)?!
Golfinray
Aug 13, 2008, 11:15:01 AM8/13/08
to
A form filter normally works after the form is opened and is a combo box that
the users select from. If you wanted the form to open on the desired record,
you would have to have a separate form to do the filtering. Do a search on
here and you can probably find one already built.
the users select from. If you wanted the form to open on the desired record,
you would have to have a separate form to do the filtering. Do a search on
here and you can probably find one already built.
0 new messages