Apply Filter to Records in form

H

hdfixitup

I have an Unbound Form with Unbound combo boxes that I enter data into. I
push a Command Button that displays my search results on a subform. The
subform's query criteria is referenced to the combo boxes on the form. My
results retrieve multiple records with the same part number. This is what I
want with my initial search. Now, I would like to be able to Group the
records on the subform. When I go to Advanced Filter/Sort, the View/Totals
option is not available. Is there a way I might Group the records on the
subform and apply a filter to show my grouped records? Any help would be
appreciated.
 

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

Creating a Search using a combo box and then creating a report. 4
Dealing with the error: unable to filter on excel hc home school 0
Clearing combo boxes and a text box 2
Trying to remove error from conflicting code 0
Filter main form to records with no related records in subform,maintain updateable recordset 4
Option Group not requerying after remove filter 5
Help creating a search form in Access XP 0
Recordset.Clone Help Needed 9

Top