default value in subform

[vicsaccess]

Thank you all for any help. I'm learning access and need help. I have a form with a subform in it. A few of the values are the same on the subform as on the form and I would like to enter these values on the form and have them also appear in the appropriate boxes on the subform. Can someone please guide me?

[NoellaG]

Hi,

if you have some default values in the main table that can be overwritten in the details table (assuming this is the situation), you can add some code in the OnCurrent event of the main form that sets the default values from the subform to the value of the corresponding fields in the main form.
The code could look like:

Private Sub Form_Current()
Me.sfrmMySubForm.Form.txtMyTextBox.DefaultValue = Me.txtMainTextBox
End Sub

[ranman256]

If the value exists in the master form, There is no need to re-enter them again in the sub form.
by the nature of the 1- many table if the master has it, so does all children.
you would be duplicating data. Is this what you need?

[vicsaccess]

Thanks for the replies but I could not get it to work. A little more clarification would be, main form vicsmainF text box "gauge" would have an input value that is saved then subform vicsprodution text box "gauge" would copy that value. I'm still trying to learn and figure out this coding. If anyone noes a good book or better way to learn please let me know.