Autofill the other field in same table using dlookup

[jones]

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.

[pbaldy]

Names with inadvisable spaces have to be bracketed, but this avoids the extra trip to the data:

http://www.baldyweb.com/Autofill.htm

[jones]

Names with inadvisable spaces have to be bracketed, but this avoids the extra trip to the data:

http://www.baldyweb.com/Autofill.htm

Hi Sir,

Thank you Sir, it help a lot. i done it.
Thank you very much.

[pbaldy]

Happy to help!

[rnodern]

Hi to all,


I have 2 table: 1. tbl Material List
2. tbl Material Supply Plan

...

if i run it say: Compile Error:
Expected: list seperator or )

Thank you in advance.

In addition, to the other excellent response, I find it handy to use underscore "_" characters in table naming convention to avoid this issue.

It is also possible to do what you want via a query.

You could just use the dlookup as an expression in the query. You can test these in the VBA immediate window to see if the dlookup works.

[pbaldy]

I don't personally like the underscore, but it's certainly an acceptable character. I would NOT use DLookup() in a query.