Dlookup Returning the first field from the list regardless of the criteria

Question

I am Working with a form with a combo box (LaborType) and a text box (LaborCost1) I have the following code on the after update event of the combo box and it returns the same value no matter the criteria.

[LaborCost1] = DLookup("LaborCost", "LaborTypesAndCost", LaborType = Me.LaborType)

That will only happen if LaborCost is the same for all LaborTypes. — Gustav, Nov 23 '21 at 16:55
There are currently two records in that table and they are not the same. — Jesse, Nov 23 '21 at 17:03

score 0 · Answer 1 · answered Nov 23 '21 at 16:28

0

If LaborType is numeric:

DLookup("LaborCost", "LaborTypesAndCost", "LaborType = " & Me.LaborType)

If LaborType is text:

DLookup("LaborCost", "LaborTypesAndCost", "LaborType = '" & Me.LaborType & "'")

answered Nov 23 '21 at 16:28

Kostas K.

8,293
2
22
28

Labor Type is Text and I tried the Code sent and it is still returning the same result no matter the criteria. – Jesse Nov 23 '21 at 16:55
Are you sure the AfterUpdate() event is firing? – Kostas K. Nov 23 '21 at 17:05
I have also run the same code on the OnChange event and I am getting the same result. So I believe that the event is firing. – Jesse Nov 23 '21 at 17:12
Well, the control should have the word `[Event Procedure]` on the relevant event in the properties/events tab - have you checked it? – Kostas K. Nov 23 '21 at 17:15
Is the combo multi-column? If yes, which column is bounded? – Kostas K. Nov 23 '21 at 17:19
Yes it is on both after update and on Change – Jesse Nov 23 '21 at 17:19
Yes it is multi column and the first column is bound – Jesse Nov 23 '21 at 17:20
So the first column should be the text for LaborType. if it's not, then give the column number where the text is located, e.g. `Me.LaborType.Column(1)` (for the second column). – Kostas K. Nov 23 '21 at 17:22
The first column is the labor type and it is formatted as text in both tables – Jesse Nov 23 '21 at 17:25
I'm not talking about the table but the combobox control. – Kostas K. Nov 23 '21 at 17:26
Yes the first column in the combo box Control is text. – Jesse Nov 23 '21 at 17:34
1

I found a spelling error in one of the tables and the code you sent is now working thank you for the help. – Jesse Nov 23 '21 at 19:35

Dlookup Returning the first field from the list regardless of the criteria

1 Answers1