vba scroll up with focus scrolling out view

[ano]

rst.FindFirst "d_t = " & str
               If rst.NoMatch Then
                   MsgBox "Record not found"
               Else
                   rst.MovePrevious
                   Me.Bookmark = rst.Bookmark
                   Me.scroll fmScrollActionBegin object does not support this property or method
                   Parent.scroll fmScrollActionBegin 
                   me.parent.scroll fmScrollActionBegin 
                   forms!balans!lbl!scroll fmScrollActionBegin 
forms!balans!lbl.scroll fmScrollActionBegin 
                   fmScrollActionBegin not defined --> add fm20.dll to preference : microsoft forms 2.0 object library
               End If
           rst.Close

i just cannot find solution for sync subform2 to subform1 without subform1 change view


the attachment shows date selected but want date newest date
union sql works faster then on dates
2lines from table in form balans subform bl ; selected date is used in 5lines from sql
d_d is vba nummering to select yesterday (d_d - 1 ) to calculate difference daily base
d_t is vba nummering to select last month (d_t - 1 ) to calculate difference (running) month base

[ano]

work around sql not use dataview. copy d_d into textbox on mainform and focus on 1st row again and change sql to the textbox ;; solved !!! but not nice

[Welshgasman]

The way to sync two subforms is to have a hidden control on the mainform that holds the value of one subform linked fields, and then link on that for the second subform.

[ano]

thanks to confirm my work around, but i had it working without help field, only wanted to adjust the scroll position that seems to be available