auto add a value in form field (1 Viewer)

[naobao]

I want to auto add a value in A FORM "PIC1" field "min qty" after update "item" field,
base on a TABLE information in "PIC2", please help how to do!

 

[Ranman256]

Did you set the textbox DEFAULT VALUE?
It auto adds this value.

 

[pbaldy]

How about:

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

 

[almahmood]

Change the Rowsource, Property of the ITEM control and write one line VBA code on AfterUpdate Event like this:

Change the ROWSOURCE of Item filed to Select ITEM_CODE, MIN_QTY FROM YourPic2Table ORDER BY ITEM_CODE.

Now go to the Format tab of Property Sheet and change the Column Count to 2 and next set Column Width = 1,0

Once you are done with the above steps now write the code on the VBE window under Control After Update Event.

Me.QTY = NZ(Me.Item.Column(1),0)

 

[naobao]

Thank you so much for everyone!!