Update Command Button in Main Form

[Alex Motilal]

I do have a MainForm and two subforms, SubForm1 & SubForm2. All the forms are having a linking field Lot_ID.




The SubForm1’s & SubForm2’s underlying tables are not related.


The SubForm1 has a date field named DateOfShifting & the SubForm2 has a date field named ShiftingDate which can have one or more records.


I want to create an Update Command button on the Main Form. On clicking the button, the SubForm2’s date field should populate with the date entered in the SubForm1

Can it be done? If so please let me know the code. Even though date can be manually entered, I want this to avoid entry mistakes.

Alex

[kd2017]

Can it be done? Yes.

But... Can you explain further about what the main form and subfroms are? Usually a main form's record has MANY records from its subform(s) (if that makes sense), so how do you pick which subform 1 date to apply to subform 2?

Can you post a screenshot of your table relation ships and your forms?