indsæt bynavn automatisk ved postnr.

You need to use a combo (drop down) instead of a text box. Use the conbo box wizard for doing this and make sure you have two columns, one for postnr and one for ByNavn. (SELECT PostNr, ByNavn from YourTable Order By PostNr)Make sure that the postnr column is the bound column. Now make a combo for the Bynavn field in the same way this time selecting the fields in the opposite order (SELECT ByNavn, PostNr from YourTable Order By ByNavn). Again make sure that PostNr is the bound column.

Now you will have two combo's whereyou can either choose postnr or ByNavn and the other column will change accordingly!

Hi Terry

Jeg har lavet den første combo hvor jeg indtaster "postnr", og den gemme "by" i en tabel, men jeg kan ikke få det til at virke med combo2 så den viser det korrekte bynavn, kender du et sted hvor jeg kan se hvordan det er gjort?

If you send me your dB I will make an example for you.

NOSPAMeksperten@santhell.dkNOSPAM

remove NOSPAM

have you received my mail?

http://www.eksperten.dk/spm/476382

thanks emilias, but are you sure you want to give me so many points?