form syncronization

  • Thread starter Thread starter Rodney1234
  • Start date Start date
R

Rodney1234

Guest
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
 
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
 

Users who are viewing this thread

Back
Top Bottom