Vba: søgning på 2 felter samtidig i en database

Det kan gøres med et OR kriterie sådan her:
strSQL = "SELECT Kundenr,Navn1,navn2, Adresse, postby FROM kundekartotek WHERE tlfnr = " & tlfnr & " OR mobilnr = " & tlfnr

If your telephone/mobile is a text field then use
strSQL = "SELECT Kundenr, Navn1, navn2, Adresse, postby FROM kundekartotek WHERE tlfnr = '" & tlfnr & "' OR mobilnr = '" & tlfnr & "'"

ja det funker bare... sender du et svar

Man må gå ud fra at det er at talfelt, da han ikke har '' om værdien i sit egen kode.

I guested they wer too otherwise it wouldnt have worked in the first place. But one never knows :o)
I prefer using text fields for telephone numbers, a bit more flexible

Ville jeg også gøre. Der skal jo ikke regnes på feltet.

The person giving me bad karma because I placed an answer on this question should consider their action!
The answer was given BECAUSE this can be a typical problem when working with telephone numbers. If I were to go round giving people bad karma just because I thought someone was after some easy points, then I would have given many people bad karma.

Throwing unjustified bad karam around doesnt help the system!