Seach By Letter

[wrc]

Hi

I would like to be able to search on a form by the first letter of a field. With a row of buttons down the left hand side with all the letters of the alphabet on which when one is clicked the from would go to the first one beginning with that letter.
Has anyone tried this sort of thing before?

 

[Rich]

Take a look at the Customers phone list in the Northwind db

 

[wrc]

Success

Thank you for the reply.

I have just had success. I added a sort string to the query
Sort String: Mid([Make],1,1)
This gave me a field populated by the first letter of the make.
I then put in a great big list box down the left hand side with my sort string and the make.

Everyone keeps telling me about this northwind but i never installed in off the access cd. Might have a look if it has good ideas on.

 

[Oldsoftboss]

Hopefully this thread might help
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=40936
Dave