Filter Form in Header

  • Thread starter Thread starter kris.king
  • Start date Start date
K

kris.king

All right what I am trying to do (not very successfully so far) is to
filter a form by several combo boxes in the header of a datasheet form.
Now if this wasn't problematic enough several of my selections appear
in the table more than once so I have for instance a Rep # 10 times
when it only needs to be in the combo box once.

Setting up and hand filtering the tables was easy enough now to just
make it easier so that my coworkers will be able to use it.

All help is appreciated.
 
well, you can add controls to the header/footer sections in form design
view, but they won't show up in Datasheet view, only in Single Form view or
Continuous Forms view.

as for eliminating duplicate entries in your combo box, see if Grouping in
the RowSource query or SQL statement will work for you. try grouping on the
Rep# field.

hth
 
I am not sure what you mean by grouping. I changed my form to
continuous view is there a way once a person filters the form that it
can then but put into datasheet view or exported to excel via a command
button.

I also am still having trouble filtering by combo and list boxes let
alone tying a few together.

I appreciate the help so far thanks.
 
I changed my form to
continuous view is there a way once a person filters the form that it
can then but put into datasheet view
Click to expand...

AFAIK, not without changing to design view and back - not a good option. but
you can set up the form in design view, using the Continuous Forms setting,
so that it looks almost identical to a datasheet view. it just takes some
work.
I am not sure what you mean by grouping.
Click to expand...

open your form in design view. click on the combo box and, in the
Properties, box, click on the RowSource property. a small button appears at
the right side, with an ellipsis (...) on it. click the button, and it takes
you into a window that looks like a query design grid. on the toolbar, click
the button that looks like a fancy capital E (or a capital M lying on its'
side). all the fields in the query grid (hopefully there are only one or
two) default to a Group By setting. close the window, saving the changes.
look at the combo box list in form view and see if the list is appropriate
now.

hth
 
Back
Top