Autofill Part Description based on Part Number

[CJSSC]

I need to autofill a textbox with information (part description) from a master BOM table based on an entered part number. I've tried OnGetFocus event procedure but I can't seem to get it right.

Thanks in advance.

CJ

 

[DanJR]

Try the AfterUpdate event of the part number textbox, e.g.:

-------
Private Sub txtPartNumber_AfterUpdate()

Me.txtPartDesc = DLookup("[PartDesciption]", "BOM", "[PartNumber] = " & Me.txtPartNumber)

End Sub
-------

Cheers,
Dan