Hi to all,
Please anyone could help me.
I have 2 table: 1. tbl Material List
2. tbl Material Supply Plan
I want to select the Item code then autofill the Desc field with description in tbl Material Supply Plan.
What i did is i make datasheet form from tbl Material Supply Plan and i choose the Desc field then make a proceedure in properties then in event tab i use afterupdate and in vba screen here is my proceedure,
Option Compare Database
Private Sub Item__Code_AfterUpdate()
Desc DLookup("[Description]", "tbl Material List", "Item Code=" & Item Code)
End Sub
if i run it say: Compile Error:
Expected: list seperator or )
Please help me to figure out this problem
Here is the sample that i want to autofill.
If i select item code it autofill in Desc field.
Project Code Work Order No Item Code Desc Reqd Qty Unit Date Needed Remarks
01B-01C-13-0006 35MPa, OPC+MS+Waterproofing/Admix SP432MS/WP20 (as per SABIC specs)
01B-01C-13-0001
Thank you in advance.