Sync/Link 2 forms

[Jim Orson]

I have a form displayed in single record view with a command button on it.
When I click the button a copy of the same form opens as a pop-up in
datasheet view. Now, I would like to synchronize or link these two forms so
when I navigate, edit or add to one, the other one follows, just like the
behavior of the single record view and datasheet view in a split view. The
difference between what I would like and the split view is that the
datasheet view is in a pop-up window rather than attached to the single
record view. Can someone please suggest a way to do this? Thanks...

 

[Tom van Stiphout]

On Thu, 23 Jul 2009 21:10:03 -0500, "Jim Orson"

You synchronize two forms by setting the Bookmark property of their
RecordsetClones equal to each other.
So in the Form_Current event you could write:
dim frmOther as form
set frmOther = forms!myOtherForm
frmOther.RecordsetClone.Bookmark = Me.RecordsetClone.Bookmark

-Tom.
Microsoft Access MVP

 

[Jim Orson]

Thank you Tom for this info. We have been traveling, but now I will work on
this.
Jim...