Northwind Customer Phone List!

[jepoysaipan]

Hi Guys,

I've been studying the Northwind Database Example for days but can't seem to get the logic behind the Customer Phone List Form (Sorry for this newbiw question, I can't seem to get the logic behind those command buttons at the bottom of the form and upon clicking it sorts out the form based on the lettered button.

I am just amazed with this design and could someone shed a light on this kind of approach on a database?

Your help is much appreciated.

Thanks a lot.

 

[Mike375]

"S*"

Right click on the "group".....not the buttons....and look at Events and you will see a macro is run...

So "S*" is anything that starts with S

 

[jepoysaipan]

Thanks Mike375.

 

[Mike375]

I have attached a little DB where you can see the NorthWinds phone list working.

This is just a form were I copied "the group" and put the table and macro from NorthWinds

In other words, if like the button system you can copy it

 

[Ron_dK]

I can't seem to get the logic behind those command buttons at the bottom of the form and upon clicking it sorts out the form based on the lettered button.

Jepoy,

The buttons used in that form are so called Toggle buttons and to each button there is an Option value assigned in the event properties.

Do a search for "Optionvalue" in Access help which explains the funcionality of togglebuttons and option values.

Hth

 

[CyberLynx]

Here is an interesting concept for ya. I use this all the time.

Just slide your mouse pointer horizontally across the Index Boxes.

.

 

[jepoysaipan]

Awesome!!!! Thanks a lot CyberLynx!

 

[Mike375]

If you use it you will get giddy and fall over

But nifty and neat stuff