Synchronization of two subforms

[StefanScheidegger]

Hello there

I have two subforms (both continuing subforms) which I try to synchronize (the table selected in subform 1 should be automatically selected in subform 2 as well).

In subform 1 (ProductDetails), Users enter data. In subform 2 (DistributionCapacities), no data can be entered.

I tried to use the following code to get the synchronization done.

Private Sub Form_Current()
Set Periode.ProductDetails.Form.Recordset = Periode.DistributionCapacities.Form.Recordset (all on one line)
End Sub

However, this does not work. MS Access brings the following error message when the form is opening:

Error 424
object required

Do you have any ideas, what is wrong? What has to be noticed that the synchronization works?

Thanks

Stefan