Alphabetical Control

N

Nick

I would like to set up a alphabetical control in a form so
that if I click on a letter in the main form's control it
bring up the first name starting with that letter in the
sub form.

Is this possible and if so where can I start?

Thanks for any assistance.
Nick
 
J

Jeff Conrad

in message:
I would like to set up a alphabetical control in a form so
that if I click on a letter in the main form's control it
bring up the first name starting with that letter in the
sub form.

Is this possible and if so where can I start?
Click to expand...

Hi Nick,

Here are a few sample files you can look at for study on this subject:

1. Take a look at the "Customer Phone List" form in the
sample Northwind database that ships with Access. It does
what you want with an option group and associated macro.
You might be able to use that form as a guide to learn
from. I've used this before.

2. You might like to try Sensei Stephen Lebans' SelectAlpha:

http://www.lebans.com/selectal­pha.htm

3. There is a similar solution that allows for any font on a command
button in the Corp Tech Demos written by MVP Duane Hookom.
The form in question is the "Data Menu Demo" in this download file:

http://www.invisibleinc.com/di­vFiles.cfm?divDivID=4

Hope that gives you some ideas.
 
Top