Access 2010 Run-time error '3464' PLEASE HELP FAST

[klund5]

Ok my problem is that this one form is resisting. The dlookup code im using is being a dick and not allowing me to continue. This code is pretty basic:

 Private Sub Itemid_AfterUpdate()
    Itemid = DLookup("Itemid", "Merchandise", "Itemid=" & Itemid)
    Itemname = DLookup("Itemname", "Merchandise", "Itemid=" & Itemid)
    Itemdescription = DLookup("Itemdescription", "Merchandise", "Itemid=" & Itemid)
    Itemtype = DLookup("Itemtype", "Merchandise", "Itemid=" & Itemid)
    Itemsell = DLookup("Itemsellprice", "Merchandise", "Itemid=" & Itemid)
    Stock = DLookup("Stock", "Merchandise", "Itemid=" & Itemid)
End Sub

The table, is called merchandise and it is fully populated, and all spelling is correct. The form is the same. HOWEVER, I continue to recieve the error.
I've used this same code structure in another form:

Private Sub Clientid_AfterUpdate()
    
    Clientname = DLookup("Clientname", "Client Data", "Clientid=" & Clientid)
    Clientuser = DLookup("Username", "Client Data", "Clientid=" & Clientid)
    Clientpass = DLookup("Userpassword", "Client Data", "Clientid=" & Clientid)
    Clientemail = DLookup("Email", "Client Data", "Clientid=" & Clientid)
End Sub

This however works???
If you can tell me where I went wrong please do soon!
PLEASE HELP ME!

 

[Anon_F]

Have you tried google?
A lot of info came up when i looked!

 

[klund5]

Ok, ive tried searching google, and have come out empty handed. The search results have nothing to do with the dlookup.
I dont know if there is a problem with my code or what...

 

[Anon_F]

Well my Access knowledge only goes up to ECDL level, Sorry.
Good luck!

 

[alow]

Is the ItemID field in the table that it pulls from a text field? Even if it only contains numeric values, if it is a text field, you'll need to use something like the following for the last part of the DLOOKUP:

"Itemid = '" & Itemid & "'"

Short of that, I probably can't help you. Good luck!

 

[V_R]

Well my Access knowledge only goes up to ECDL level, Sorry.
Good luck!

You really need to start thinking before you post......