Question Update a main form using query subform

[mazamizo567]

Hi guys my question is simple
just after updated the "Order 1 of the Main FORM" I want the "materiel Desc: on the main FORM" to be auto filled exactly like the "Material Desc: on the Sub-query Form" without copy and paste it.

the main form is:- Daily Work
the query sub-form is:- daily order query subform3

thanks and regards

 

[jdraw]

Please show us how the tables behind the form are related.

How do Daily Work, Order and Material fit together? in simple terms

Why would you want Material Description in 2 places on the form/screen?

 

[mazamizo567]

i need the [Material Desc] on the parent form catch the [Material Desc] on the query subform according to the [order1]

its for printing

 

[arnelgp]

use the OnCurrent event of your subform:

private sub form_current()
me.parent![material desc] = me![material desc]
end sub