I've used this a million times, but for some reason it now only returns data from the first record in the table no matter what the part_Number is.
Private Sub Part_Number_LostFocus()
Dim varIDesc, varIName
varIName = DLookup("Part_Name", "Item", "[Part_Number] = [Part_Number]")
varIDesc = DLookup("Part_Description", "Item", "[Part_Number] = [Part_Number]")
If (Not IsNull(varIName)) Then Me.Part_Category = varIName
If (Not IsNull(varIDesc)) Then Me.Part_Desc = varIDesc
End Sub
Any thoughts?