Navigerbar oversigt

This is just a suggestion. You could the tree view control to show all letters of the alphabet and in under each letter youhave the names which start with the letter. Then when you click on the name the information is displaye din a form (maybe a sub form) where you can make your alterations.

Another idea is to have a number of buttons on e for each letter of the alphabet. Then when you click on a button you alter the record source for a form selecting only those which strart with that letter.

I am not so compentent in using Acces - what is the 'tree view control' or how do I make the bottons for the alphabet?
/od

well I hope you can understand this or you have problems.

OK we will try and keep it simple.

make a form using the wizard and choose your tabel containing your adresse data as the record source.

Make this a Continuous Form or a data sheet to show ALL records.
Now add a button to the form header and make the Caption (text) = A
At the same time add another button with the caption B

Now in the on Click event for BOTH buttons add =SelectRecords()
EXACTLY as I wrote "=SelectRecords()"

Now add a text field and name it txtChar, this canbe hidden when it is all working.


Now you need to add this to the forms code


Function SelectRecords()

    On Error Resume Next
    Me.txtChar = Me.Controls(Screen.ActiveControl.Name).Caption
   
    Me.Requery


End Function


Now you need to alter the forms record source to something like this

SELECT *, Format(Left([efternavn ],1),">") AS firstchar
FROM YourTable
WHERE (((Format(Left([efternavn ],1),">"))=[Forms]![TheNameOfTheForm]![txtChar]));


YourTable is the name of the table
TheNameOfTheForm thi sis the name of the form

oledr>hows it going here?

HeeeeLLLOoooo!

Hej

Jeg er som sagt ikke så stærk i Access, så jeg roder stadig med dit forslag.

/q

oledr dont you think its about time you closed this question, we cant wait until you learn Access :o)