form syncronization

[Rodney1234]

Hello to all. I have two forms within my database, with the main form being number 1. WHen a record is located on form 1 via a combo box, of course the current record is changed. I then switch to form 2, but the current record on this form does not match the record previously found on form 1. THe two forms both use the same table. Any help would be greatly appreciated.
Thanks in advance

 

[mvos]

Hi,

Try this on the OnCurrent event of form1

Dim rs as object

With Forms![Form2]
Set rs = .RecordsetClone
rs.Findfirst "[MyField] = " & Me.MyControl
.BookMark = rs.BookMark
End With
Set rs = Nothing