Northwind Database Question ?

[TonyB]

Hi,
I'm quite new to Access, and I'm looking at the Northwind sample database
for examples on how access works.
I'm may be being very stupid but I am having problems understanding the form
Customer Phone list, which displays a phone list of all customers.
The form has a set of buttons, A/B/C ... which you click on to select
entries in the customer database beginning with that letter. But I cannot
see how the ABC... buttons call the underlying macro which does the
filtering. Also these "buttons" do not have a on click event, and none of
the events for that "button" appear to call the macro. So I'm baffled as to
how this works ?
Can anyone explain how this works ?
Thanks
Tony

 

[fredg]

Hi,
I'm quite new to Access, and I'm looking at the Northwind sample database
for examples on how access works.
I'm may be being very stupid but I am having problems understanding the form
Customer Phone list, which displays a phone list of all customers.
The form has a set of buttons, A/B/C ... which you click on to select
entries in the customer database beginning with that letter. But I cannot
see how the ABC... buttons call the underlying macro which does the
filtering. Also these "buttons" do not have a on click event, and none of
the events for that "button" appear to call the macro. So I'm baffled as to
how this works ?
Can anyone explain how this works ?
Thanks
Tony

Don't click on any one individual button. Click on the edge of the
rectangle that surrounds the entire group of buttons (or select
CompanyNameFilters in the Object tool button dropdown).
The individual buttons are part of the "CompanyNameFilters" Option
Group.
When the option group is highlighted, click on the Event tab on the
Group's property sheet. Note that the AfterUpdate event calls the
"Customer Phone List.Alpha Buttons" macro. That is what filters the
records.

 

[George Nicholson]

- Each Toggle button has a unique value of 1 to 27 assigned to it and
resides within an OptionGroup (look for the rectangle that encompasses all
of them).
- Only one button within the OptionGroup can be pressed at a time so, at any
given time, the OptionGroup value will be 1-27, depending on which button is
pressed.
- The OptionGroup has a macro ("Customer Phone List") assigned to its
AfterUpdate event which fires whenever a the value of the OptionGroup
changes (i.e., a button is pressed). The macro then changes the filter being
applied to the form based on the new value.

HTH,

 

[TonyB]

Hi Fred & George,
Thanks for the clear explanation. I totally missed the option group
surrounding the buttons !
Tony