dlookup på datatypen: text (string)

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

Hvor Me!Navn indeholder data i formularen der skal matche data i Tabel2.
Me!Tekst4 modtager resultatet af DLookUp.

Ved alfanumeriske felter skal der apostrof ' omkring kriteriet.

Den findes ikke det ønskede. -

min kode:

Dim strVNo
      strVNo = 41
      varPris = DLookup("[decimaltal]", "t_Ydelse", "[VNo] = '" & strVNo & "'")

Din parameter er vel ikke text men tal!

you say it is a text you are looking for but is it a text field in the table also?

Dim strVNo
      strVNo = 41
      varPris = DLookup("[decimaltal]", "t_Ydelse", "[VNo] = " & cInt(strVNo) )

Terry->clng i stedet for cint :o)

More than likely Thomas but how will we ever know if we dont get any comments :o)

in the meanwhile, tell me: how is your new job and how is your own business doing?

New jobs great, so great I have very little time for eksperten which maybe is a good thing. Own business is rather quite at the moment which is also quite nice! It was getting too much having a fill time job and working all hours on other things. No time to myself and family! I dont really do anything to find jobs at the moment but maybe will be a little more active after the summer. Hows your work going wil Milla? You seem to be more active on eksperten too little "real" work to do? :o)

Now I'm off home for the weekend, have a good one too!

thnx....U 2

I am just as busy as before....These days I am just working from home on a large project. And these days there ain't that much activity here on the Eksperten.dk. So it just seems like I am here all the time ;o)
Have a good vacation, when you get to that :o)

takker - det lykkedes - begge hjalp-