list view

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

Guest

Hi, how can I create a view of records on the form that shows all the records
and there is a alphabetical list on one side so that when I peress the letter
'a' it shows oor goes to records starting with 'a' just like in outlook
contacts. thanks
 
Couple of different ways to acheive this solution...Here are some ideas:

Use a form that displays the letters of the alphabet in some way (i.e. combo
box, list box or even command buttons if you want).

Use a subform that is based on a query to find all records that start with
the given letter...try using the Like operator. Using the combo or list box
is probably the easiest but this also could be done by creating a separate
command button for each letter if that is most appropriate for your users.

HTH
 
Hi, I was able to copy customer phone list table into my database and it
works fine, but I want to change the view to show the records outlook style,
like the records move horizontally and theere is no vertical scroll bar. do I
need to change the properties? thanks
 
Back
Top