Filter

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

I have a form that opens with a filter, then has 4 other command buttons that
give options for viewing other filters.

I also have a combo box on the form for a lookup of the specifi record the
user wants to view. Is it possible to have that combo box also be filtered
based on the current filter being used?
 
Donna said:
I have a form that opens with a filter, then has 4 other command buttons that
give options for viewing other filters.

I also have a combo box on the form for a lookup of the specifi record the
user wants to view. Is it possible to have that combo box also be filtered
based on the current filter being used?
Click to expand...

I figured it out myself - on the click event of the command button that
filters the form I added the line combo30.rowsouce = stFilter, where stFiler
is the query running behind the form filter
 
Back
Top