DLookup

[aviscomi]

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?

[pbaldy]

See if this helps:

DLookup Usage Samples

[aviscomi]

Ugh!...I feel like an idiot!

Thanks!

[pbaldy]

Happy to help, and welcome to the site!