I am having trouble with 'dlookup'

Question

I am new at this so I apologize for any stupid questions.

Objective: When the user selects a location (Combo box) for an item previously selected, I want dlookup to give me a numeric value (QPC) saved in a other table. All the information is save an a new table.

Row source for item: SELECT Main.ITemID, Main.Description FROM Main;

Row source for location: SELECT Location.Location, Location.Description FROM Location;

Originally, table Main had the numeric value (QPC) saved in the same record as the item. I moved the value to a different table Item_Detail

I will change 15132-0A020 to the value selected but for now I am hardcoding it because I can't get it to work. Also, I have google Error 2465 but I get more confused the more I read.

Private Sub Location_AfterUpdate()
DoCmd.OpenTable "item_Detail"
Me.Units_in_UOM.Visible = True
Me.Units_in_UOM = DLookup([QPC], "Item_Detail", "[ItemId]=15132-0A020")
End Sub

Answer 1

等待大神答复