apply form filter on open form

  • Thread starter Thread starter Smoki
  • Start date Start date
S

Smoki

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)?!
 
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.
 
Back
Top