By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,221 Members | 1,121 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,221 IT Pros & Developers. It's quick & easy.

Question about Allen Browne's form filter instructions

P: n/a
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
Dec 29 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Dec 29 '07 #2

P: n/a
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
Dec 29 '07 #3

P: n/a
On Dec 29, 9:50 am, Thelma Lubkin <the...@alpha2.csd.uwm.eduwrote:
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.
Dec 29 '07 #4

P: n/a
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
Dec 29 '07 #5

P: n/a
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
Dec 29 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.