Scrolling is a nightmare!???????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form listing ALL clients we have on our database which, is quite a
lot!!!!
Is it possible to select a letter on the keyboard and the list automatically
directs you to the beginning of that relevant letter? This would be very
helpful as the list of clients is continuing to increase day by day!!

If this is possible, how??

Any info would be great. thanks!!
 
Kerry,

Make a new form and use an unbound combo box on it to display/select
customer names. When the user starts typing in a name, it works the way
you want it (for every letter typed, not just the first!).
Then in this same form, insert the previous one as a subform, and link
the customer name in it (or, better, a customer ID if you are using one)
to the combo on the main form (whci should be made to include and return
the customer ID field, if you go that way). This should do exactly
what you want.

HTH,
Nikos
 
I'm not sure I see the advantage of using a separate form. As I understand
the question this can be done on one form. The combo box wizard will let you
create a combo box on the form that can be used to select a record based on
the contents of the combo box. Make sure the combo box Auto Expand property
is set to Yes (in the combo box's property sheet, on the Data tab). I think
the wizard will do it that way by default anyhow.
 
Hi Kerry

Take a look at form Customer phone list in the northwind database there is
good example how to filter by alphabet

Herman
 
Thanks Hermie, that is quite a good idea!!

hermie said:
Hi Kerry

Take a look at form Customer phone list in the northwind database there is
good example how to filter by alphabet

Herman
Click to expand...
 
Back
Top