PeterDuthie
Programmer
Hello all. I'm stumped with this one and would be very grateful for some help.
I have a Form with contains a tab control with a subform on each of the three tab pages. (It so happens that there is a one to many relationship between page 1 and 2 and page 1 and 3. The database is growing fast and a navigation aid is required to move around the records in the subform on page 1. I'm having a hell of a time trying to get the usual
Me.RecordsetClone.FindFirst "[Record Number] = " & Me![FindRecordBox]
Me.Bookmark = Me.RecordsetClone.Bookmark
scheme to work.
It's in the syntax for addressing the [FindRecordBox], I suppose, but help....
Cheers,
Peter
I have a Form with contains a tab control with a subform on each of the three tab pages. (It so happens that there is a one to many relationship between page 1 and 2 and page 1 and 3. The database is growing fast and a navigation aid is required to move around the records in the subform on page 1. I'm having a hell of a time trying to get the usual
Me.RecordsetClone.FindFirst "[Record Number] = " & Me![FindRecordBox]
Me.Bookmark = Me.RecordsetClone.Bookmark
scheme to work.
It's in the syntax for addressing the [FindRecordBox], I suppose, but help....
Cheers,
Peter