How to copy a filed value from a form to a subform

G

Guest

Hi. I with a blank.

I have a form and inside I have a subform.

I want to type a value in a text field on the form and then I want that the
filed of subform gets the same value that was typed in the filed of textbox.

Main form name: Plano
Main form textbox: Quant

subform name: Plano_subform
subform textbox name: Quant_producao


How?
 
G

Guest

Private Sub Quant_AfterUpdate()
Forms!Plano!Plano_subform.Form!Quant_producao = Forms!Plano!Quant
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
Unremovable horizontal scroll bar on subform 1
Subform Subtotal 1
Validation Rules for a Control on a Form (?) 4
Running Total from a Subform 1
Update subform with combobox change on main form 1
Using an append query in a subform 1
Retrieve a value from an unbound control on a subform 4

Top