Question about Allen Browne's form filter instructions 
December 29th, 2007, 02:55 PM
| | | |
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
|
December 29th, 2007, 03:45 PM
| | | | re: Question about Allen Browne's form filter instructions
Functionally the location of the combo box is irrelevant, Allen is only
putting it in the header for aesthetic/ergonomic reasons.
"Thelma Lubkin" <thelma@alpha2.csd.uwm.eduwrote in message
news:fl5mqq$nat$1@uwm.edu... Quote:
>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
| |
December 29th, 2007, 04:05 PM
| | | | re: Question about Allen Browne's form filter instructions
On 29 Dec 2007 14:50:02 GMT, Thelma Lubkin <thelma@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. Quote:
>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
| |
December 29th, 2007, 04:15 PM
| | | | re: Question about Allen Browne's form filter instructions
On Dec 29, 9:50 am, Thelma Lubkin <the...@alpha2.csd.uwm.eduwrote: Quote:
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. |
December 29th, 2007, 04:25 PM
| | | | re: Question about Allen Browne's form filter instructions
Thelma Lubkin wrote: Quote:
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 |
December 29th, 2007, 07:15 PM
| | | | re: Question about Allen Browne's form filter instructions
Rick Brandt <rickbrandt2@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
|  |
| | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 225,720 network members.
|
