Equal Fields across tables/forms

[jack_attridge]

Hi guys,

I have a few fields that are the same across a couple of forms and sub-forms (each form/sub-form being represented by a different table). I would like for data entry into one field to ensure that the data is autofilled into the other. ie if I type 'ENG' into field 1 on form 1, it will autofill the equivalent field in sub-form 2 as 'ENG' so that I do not have to type the same thing twice. These entries are not unique or in any order as it is variable depending on the entry and so they can't be linked as primary keys and foreign keys. So how would I do this? I would like to avoid VBA is possible.

Thank you for any help.

Jack

 

[Mr Smin]

The VBA could be quite modest.
In the field on frm1 choose properties>events>after update>code builder

code is something like

Private Sub field1_AfterUpdate()
Forms!sub-form2!yourfield=Me!field1.value
End Sub