Is it possible to have a value from a main form auto fill into a subform? **Pictures below**

[Xterra14s]

I inserted a picture in hopes of making it easier.


What I want to do is have the number I type in in section 1 automatically appear in section 2. The way I currently have it it does work but now properly. I have set field 2 to show field 1 as the default value but it wont update when refreshing. I have to click between tabs in order for it to do so. Is there a VBA code or something that will let me do this?

Attachment 25344

[John_G]

Try setting subform Field 2 in the after update event of main form Field 1:

forms![MainFormName]![SubformContainerName].form![Field2] = forms![MainFormName]![Field1]

Or, using Me! to refer to the main form:

Me![SubformContainerName].form![Field2] = Me![Field1]

If you want the Subform field to be refreshed each time you move to a new record on the main form, put that code in the main form's On Current event as well.