Northwind Customer Phone List!

jepoysaipan

Registered User.
Local time
Today, 18:44
Joined
Nov 4, 2007
Messages
133
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.:)
 
"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
 
Thanks 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
 

Attachments

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
 
Here is an interesting concept for ya. I use this all the time.

Just slide your mouse pointer horizontally across the Index Boxes.

.
 

Attachments

If you use it you will get giddy and fall over:D

But nifty and neat stuff
 

Users who are viewing this thread

Back
Top Bottom