Synchronised Subforms

[smckells]

Hi

This one has been annoying me for days now because I know it can be done and I've done it before but can't remember how.

I have a form which contains two subforms. Subform1 is a datasheet and contains summary data. Subform2 is the detail relating to the records in Subform1. When the user opens the entire form Subform1 will contain multiple rows but subform2 will only display the selected row from subform1. However when I move to a different row in subform1 the record in subform2 does not change. This is basically the reverse of a one-to-many form.

Would really appreciate some help

Steve

 

[Mile-O]

Which of these threads is the parent and which is the child, I don't know.

Double Post

 

[WayneRyan]

Mile,

You are posting on the child thread, the parent has a lot more
activity.

Wayne

 

[gibsonn]

This may work. Have you tried using bookmarks? e.g.

dim rs as object
Set rs = Me.Recordset.Clone
rs.FindFirst "[INC_ID] = " & Str(Me![Combo62])
Me.Bookmark = rs.Bookmark
I have this code a form which contains a subform and works on the afterupdate event, you may want to use the keypress event if you are tab between records in your first subform.

Hope this helps