Sync Subform to MainForm VBA Error 424 Object Required

haident used Ask the Experts™
VBA is not my strong point, so this is problably something simple, but I think I am closely following the expample at to achieve a "Split Effect" by synchronizing two forms that have the same RecordSource.

However, when I open the main form, frmEntitiesMaintenance, I get a VBA run-time error 424, object required. See attached file. SyncForm.mdb
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
use these codes

Private Sub Form_Current()
'tblEntities.Form.RecordsetClone.FindFirst "EntityID = " & Me.EntityID
'tblEntities.Form.Bookmark = tblEntities.Form.RecordsetClone.Bookmark

With Me.[Entities Name List].Form.RecordsetClone
    .FindFirst "EntityID = " & Me.EntityID
    If Not .NoMatch Then
    Me.[Entities Name List].Form.Bookmark = .Bookmark
    MsgBox "Record not found"
    End If
End With

End Sub
Top Expert 2016

here is the revised db


I guess I need some VBA training, as I don't really understand, but it works - thanks for the speedy response!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial