Question Add data from the drop-down list for a field in another table

[shamal]

HI.

Example contains 4 tables

tables Name_Cus and Sales

and
tables tables and Comp_Mwad

It was the 4 forms design

I needed is How can I add the Comp_Mwad to the sales table

When choosing a name from a drop-down list of material placed in Mada field from the sales table as well as the purchase price of the material is placed in a yellow field.

 

[Ranman256]

the source query of the combo should have fields:
Item#, Price

when user selects the ITEM, fill in price by the afterupate event

 sub cboLOM_afterupdate()
 txtPrice = cboLOM.column(1)
 end sub

note: the combo has a column count of 2, but in code counting starts at zero,
hence .column(1)

 

[shamal]

the source query of the combo should have fields:
Item#, Price

when user selects the ITEM, fill in price by the afterupate event

 sub cboLOM_afterupdate()
 txtPrice = cboLOM.column(1)
 end sub

note: the combo has a column count of 2, but in code counting starts at zero,
hence .column(1)

Application on the attached example , please

 

[shamal]

the source query of the combo should have fields:
Item#, Price

when user selects the ITEM, fill in price by the afterupate event

 sub cboLOM_afterupdate()
 txtPrice = cboLOM.column(1)
 end sub

note: the combo has a column count of 2, but in code counting starts at zero,
hence .column(1)

hi
Please apply the solution example

 

[shamal]

arnelgp
up
up

 

[shamal]

up
up
up
up please

 

[shamal]

up
up
up
up
up