Record Selector out of Sync

[Guest]

Hi,

I have a main form with two sub forms.

The 1st subform displays a summary list, the main form displays the details
of whatever record is selected in the 1st subform, and the 2nd sub form
displays other related data.

When a record is selected in the 1st subform, the main form and subform # 2
change to reflect the new record selected.

I use the following code to do this:

If Not IsNull(Me!ID) Then
Parent.RecordsetClone.FindFirst "ID= " & Me.ID
If Not Parent.RecordsetClone.EOF Then
Parent.Bookmark = Parent.RecordsetClone.Bookmark
End If
End If

The problem I am having is when a record is selected in subform # 1, and the
main form and subform #2 update (via the above code), the record selector in
subform #1 goes to the 1st record - even though this is not the current one
displayed in the main form and sub form # 2.

How can I keep the record selector in subform #1 on the original record that
was selected after the above code has executed?

Any help is always greatly appreciated...

Cheers,
GLT.

 

[Jeff Boyce]

I'm not clear on how you've implemented the design you describe...

A more common scenario is to use a main form to select a record and have the
subform display detail records. You can accomplish this by having the main
form use an unbound combobox to help in selecting the mainform record.

More info, please...

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

Is subform#1 tied to the main form via a child/master relationship?

 

[Guest]

Hi Dale,

No the subform # 2 and the mainform are linked via the child/master
relationship.

Cheers,
GLT