Newbie Dlookup problem

[opopanax666]

Hi everyone,

Complete Access newbie trying to get to grips with this stuff...

• I have a table ("tblProductie") which contains 2 colums ("Pcode" & "Locatie");
• I have a form ("frmLocatie"), containing a combo box ("cboCode") which lists all "Pcodes", and a text box ("txtLocatie");
• I have following code:

Option Compare Database
 
Private Sub cboCode_AfterUpdate()
txtLocatie = DLookup([locatie], "tblproductie", "[pcode]=" & cboCode)
End Sub

but when I use the combo to choose a "Pcode", so that "txtLocatie" shows the corresponding value of "Locatie", I get an "error 2465 can't find field | (vertical line)"...

Anybody know what I did wrong? Thank you.

[SoftwareMatters]

Have you checked the data in the table?

[opopanax666]

Have you checked the data in the table?

Everything ("Pcode" & "Locatie") is in text format, if that's what you mean...

[SoftwareMatters]

No, I meant the actual data in the table i.e. the records.

If PCode is text then you need to add some quotes like this:
txtLocatie = DLookup([locatie], "tblproductie", "[pcode]='" & cboCode & "'")

[opopanax666]

Nope, still gives the same error, not finding "|"...
I can see, however, why your solution might have solved be the problem, but the "Pcodes" are in fact formed by a letter followed by 6 numbers, so there can be no mistake as to whether it's a string or not.
The location codes, however, are stored as text, but are in fact 6 numbers, so maybe the problem lies there, but I don't know where to insert single quotes in the expression. I tried:

Option Compare Database
Private Sub cboCode_AfterUpdate()
txtLocatie = DLookup("'" & [locatie] & "'", "tblproductie", "[pcode]='" & cboCode & "'")
End Sub

but no go

I'm a bit stumped, I thought this was one of the easiest things to do in Access, but obviously not

[maximus]

if pcode is a number Field.

Dlookup("[Locatie]","tblproductie","[pcode]=" & Me.cbocode)

if pcode is a text Field:
Dlookup("[Locatie]","tblproductie","[pcode]='" & Me.cbocode & "'")

Depending on the type of the Field use one of the following.

[maximus]

is your problem solved

[opopanax666]

is your problem solved

Well, there's no error message anymore, but nothing is shown in the textbox "txtLocatie", and when I insert a msgbox in the code, it returns a null error for "txtLocatie"...

Never mind. By searching the web I was reminded of Northwind. This example db has been used for years to explain stuff.
So what I'm gonna do is have a deeper look at NW, and maybe I'll get the hang of the "logic" behind Access a bit more...

So for the moment I'll mark this post as "Solved", and thank you both very much for trying to help. Cheers!