Sync Subform to MainForm VBA Error 424 Object Required

haident
haident used Ask the Experts™
on
VBA is not my strong point, so this is problably something simple, but I think I am closely following the expample at http://msdn2.microsoft.com/en-us/library/aa163981(office.10).aspx#odc_offtips_topic7 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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
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
    Else
    MsgBox "Record not found"
    End If
End With

End Sub
Top Expert 2016

Commented:
here is the revised db
SyncForm.mdb

Author

Commented:
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