Lookup

use the wizard to create youe combo. when you choose the combo from the toolbox it starts the wizrd

Stringsearch er den søgestreng du vil finde.
Kriteriet er, at du vil finde indholdet af feltet \"Gade\" i Tabel2, hvor \"Navn\" er = Stringsearch.

Dim Stringsearch As String
Stringsearch = Me!Navn
Me!Tekst4 = DLookup(\"[Gade]\", \"Tabel2\", \"[Navn]=\'\" & Stringsearch & \"\'\")

Koden gælder i Access97 for et alfanumerisk felt.

If the combo box is on th eform where you want to find the record then use th ewizard to create the combo. It will make the code to find th especific record in the form. (NO NEED TO CODE ANYTHING)

Det var da på tide!!!!