Filtering data in a subform using a combo box

T

Tony Scullion

Hi Group,

I have a main form (frmSearch) and a subform
(frmSearchSubForm). On my main form I have a combo box
(xMeasuresMeasures). I am trying to filter the data in
the subform depending upon the selection made in the combo
box.

The data in my subform is populated by a query
(qrySearch). The query contains a lot of Nulls. How do I
filter the data in my subform using the combo box so that
it removes the Nulls during the filtering process to show
selected data only? I would then anticipate a button to
reverse this process to show all records.

Thanks in anticipation.

Tony
 

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
Trouble Filtering a Sub Form With Combo Box Options 2
Filtering a subform using many combo boxes 7
Form -> Combo to a SubForm 3
Several combo boxes (with "All" option included) in a form/subform 4
Subform Filter Problem 1
Conditional Totals in Subform 0
Dependant combo box in subform 5

Top