Question about Allen Browne's form filter instructions

[Thelma Lubkin]

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

[Baz]

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

"Thelma Lubkin" <th****@alpha2.csd.uwm.eduwrote in message
news:fl**********@uwm.edu...

>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

[Tom van Stiphout]

On 29 Dec 2007 14:50:02 GMT, Thelma Lubkin <th****@alpha2.csd.uwm.edu>
wrote:

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
------
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

[lyle]

On Dec 29, 9:50 am, Thelma Lubkin <[e-mail]:

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

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.

[Rick Brandt]

Thelma Lubkin wrote:

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

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.

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

[Thelma Roslyn Lubkin]

Rick Brandt <ri*********@hotmail.comwrote:
: Thelma Lubkin wrote:
:I quote:
:"With an unbound combo in the form's header, you could provide a
: ------
:simple interface to filter products from one category."
:>
: 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.

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
: --
: Rick Brandt, Microsoft Access MVP
: Email (as appropriate) to...
: RBrandt at Hunter dot com