Filter

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?
 
D

Donna

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
First Subform record gets modified when closing form 3
Split form 0
Filter Combo boxes using Visual Basic 1
Combo Box Filter 1
"Reset" combo boxes 4
multiple filters 4
Trouble Filtering a Sub Form With Combo Box Options 2

Top