DLookup

[D Willett]

Aaaargh

Trying to get the customer onto my form using DLookup.

DLookup("Customer", "tblSales", "SalesOrderID = " & Forms![frmSales]!SalesOrderID)

Should return the "Customer" from "tblSales" where "SalesOrderID" from "tblSales" = "SalesOrderID" on the current form "frmFitting"

[Rudi]

You say your current form is called frmFitting, but the expression refers to the form frmSales?

Maybe this: =DLookup("Customer", "tblSales", "SalesOrderID = " & Forms![frmFitting]!SalesOrderID)

[D Willett]

Just the Job Rudi .

Thanks

[Sgte]

Help please: I am struggling to get my DLookup working
Its parameters are Client name is the field I want returned, from the QueryAllClientnames2 where TRIndCode is in the query I am woking in equals the field Code in the query all clint names 2
=DLookUp("Client Name","QryAllClientNames2","TRIndCode =" [QryAllClientNames2]!

Code: Select all

 ")

What have I got wrong please?

[HansV]

If Code is a number field:

=DLookUp("Client Name","QryAllClientNames2","Code=" & [TRIndCode])

If Code is a text field:

=DLookUp("Client Name","QryAllClientNames2","Code=" & Chr(34) & [TRIndCode] & Chr(34))

Chr(34) is the double quote character ".

[Sgte]

I regret that having pasted both of your lines of code into the expression builder that they don't work! :-( Any further thoughts please?

[HansV]

I'd have to see a copy of the database...

[Sgte]

Ok, thank you very much Hans.