Question about Allen Browne's form filter instructions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thelma Lubkin - 29 Dec 2007 14:50 GMT

I quote:
"With an unbound combo in the form's header, you could provide a
------
simple interface to filter products from one category."

I've underlined my uncertainty: is the combo placed in the header
to have a reasonable organization of the form, or will this not work
unless the combobox is in the header?
...sure I could try it, but I don't get access to Access often enough,
and anything I do requires lots of error correcting before it works,
so I've come here to the people who know.

thanks, --thelma

Reply to this Message

Baz - 29 Dec 2007 15:44 GMT

Functionally the location of the combo box is irrelevant, Allen is only
putting it in the header for aesthetic/ergonomic reasons.

>I quote:
> "With an unbound combo in the form's header, you could provide a
[quoted text clipped - 9 lines]
>
> thanks, --thelma

Reply to this Message

Tom van Stiphout - 29 Dec 2007 16:04 GMT

It would work anywhere on the form. The header is just a more common
place to put such controls, just like the footer is commonly used for
command buttons. But they work anywhere on the form as well.

-Tom.

>I quote:
>"With an unbound combo in the form's header, you could provide a
[quoted text clipped - 9 lines]
>
> thanks, --thelma

Reply to this Message

lyle - 29 Dec 2007 16:07 GMT

> I quote:
> "With an unbound combo in the form's header, you could provide a
[quoted text clipped - 9 lines]
>
> thanks, --thelma

With a continuous form it's likely that one will want to see only one
combo-filter, hence its location in the form header or footer. Even
with a single-record form, locating the combo-filter in the header or
footer separates it clearly from the data.

Reply to this Message

Rick Brandt - 29 Dec 2007 16:21 GMT

> I quote:
> "With an unbound combo in the form's header, you could provide a
[quoted text clipped - 9 lines]
>
> thanks, --thelma

In addition to the other comments if you use this on a read only form and have
the possibility that some filters could return zero records then this will cause
the detail section of the form to go completely blank. In that case having the
ComboBox in the detail section means the user would be trapped there since the
ComboBox would also vanish when the filter was applied.

Having it placed in the footer or header avoids that.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Thelma Roslyn Lubkin - 29 Dec 2007 19:09 GMT

:> I quote:
:> "With an unbound combo in the form's header, you could provide a
[quoted text clipped - 8 lines]
: when the filter was applied.
: Having it placed in the footer or header avoids that.

I don't understand this; if the combobox is filled from a values
list, why should that disappear if there are no records returned by
the filter? Thanks to all for setting this straight for me.

--thelma

Reply to this Message