Simultaneously data edit in main form and sub form

[ashutosh2018]

I have a database in MS Access. In that database there are five common fields/variables for Main form and sub-form.

Generally when I enter data in my main form it's auto populate in the sub-form (those common five fields) also.

But after finished the data entry (say after one week) when need to edit any field in the main form it's not editing simultaneously in sub-form.

I am not expert in VB code but know how it work. Can anybody help me on this?

[twinnyfo]

ashutosh2018,

Welcome to Bytes!

I do not htink this should require any VBA. If these five fields are common to both, then teh Sub-Form should have a Parent-Child relationship based upon those five common fields. Then, when the parent is updated, the child is automaticlaly updated.

Hope this hepps!