Hello, I have searched the forums for help and got several references to what i think i need but i still just can't make it work. I think it's to do with recordset clone :
On the MAINFORM is a Tabcontrol with 5 tabs.
Each tab(page) has a subform.
>Each subform's property is set to SINGLE FORM view with cmdButtons to scroll between records on the subform
All subforms are linked to MAINFORM with "pat_id" (PK, Autono.)
On the MAINFORM there are 2 cmdButtons for "Next Record" and "Previous Record"
NEED HELP with the following :
When moving between records (ie. currentrecord) on the MAINFORM, then ALL the subforms must always default to the LAST record for that subform. For example:
If the user is looking at "Subform 3" and clicks the "next or previous record" button on the MAINFORM , then "Subform 3" must always display the LAST related record.
What i have at the moment is > On each SUBform's OnOpen event :
This is okay for the first opened record of the MAINFORM but ofcourse no longer applies when I move between records on the MAINFORM
Any advice please.