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

First Subform record gets modified when closing form 3
multiple filters 4
Filter Combo boxes using Visual Basic 1
Combo Box Filter 1
Using Combo Box on Form with Sql view to filter 5
"Reset" combo boxes 4
Tabbing through form fields 3
Subform Filter Problem 1

Top