Creating shortcut buttons?

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Help please. I am trying to write an address database, more to learn access
than out of necessity!
I have managed to design the form and the tables load okay into it. But now
I want to add buttons to jump to the name of the initial letter.

I have added 26 command buttons labelled A to Z. But how do I write the code
to make it go to the letter of the alphabet that it corresponds to? For
instance pressing 'S' should take me to the first record of names starting
with 'S'.
Sorry if I haven't explained it to clearly.
Appreciate any help on this.

Thanks

Dan
 
Look at the customer phone list form in the Northwinds Sample database to
see one way of doing it.

Bob L.
 
Thank you very much for that Bob. That was just what I required. Now I have
to figure out how to write or copy that macro to my own database!
But at least now I can learn from that sample.
Again many thanks.

Regards

Dan
 
Back
Top