Connecting Tech Pros Worldwide Help | Site Map

Question about Allen Browne's form filter instructions

 
LinkBack Thread Tools Search this Thread
  #1  
Old December 29th, 2007, 01:55 PM
Thelma Lubkin
Guest
 
Posts: n/a
Default Question about Allen Browne's form filter instructions

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

  #2  
Old December 29th, 2007, 02:45 PM
Baz
Guest
 
Posts: n/a
Default 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

  #3  
Old December 29th, 2007, 03:05 PM
Tom van Stiphout
Guest
 
Posts: n/a
Default 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
  #4  
Old December 29th, 2007, 03:15 PM
lyle
Guest
 
Posts: n/a
Default 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.
  #5  
Old December 29th, 2007, 03:25 PM
Rick Brandt
Guest
 
Posts: n/a
Default 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


  #6  
Old December 29th, 2007, 06:15 PM
Thelma Roslyn Lubkin
Guest
 
Posts: n/a
Default 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


 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

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 220,662 network members.