Hi there,
I used the following code happily, but it no longer seems to work and I can't work out why. I've recently moved from windows 2000 to XP could this be the reason.
The code allowed me to make changes to a subform, then on update refresh another subform with the focus on the record that was bookmarked by the code.
'save updates
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
'bookmark current record
bk = Forms!frmInstallationoutlook.sfrmDataEntrySummaryView.Form.Bookmark
'refresh subform
Forms!frmInstallationoutlook.sfrmDataEntrySummaryView.Form.Refresh
'move record to bookmark
Forms!frmInstallationoutlook.sfrmDataEntrySummaryView.Form.Bookmark = bk
'set focus on bookmarked record
Forms!frmInstallationoutlook.sfrmDataEntrySummaryView.SetFocus
Does anyone have an inckling as to why this may have stopped working or is there another way I can bookmark?
Thanks
I used the following code happily, but it no longer seems to work and I can't work out why. I've recently moved from windows 2000 to XP could this be the reason.
The code allowed me to make changes to a subform, then on update refresh another subform with the focus on the record that was bookmarked by the code.
'save updates
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
'bookmark current record
bk = Forms!frmInstallationoutlook.sfrmDataEntrySummaryView.Form.Bookmark
'refresh subform
Forms!frmInstallationoutlook.sfrmDataEntrySummaryView.Form.Refresh
'move record to bookmark
Forms!frmInstallationoutlook.sfrmDataEntrySummaryView.Form.Bookmark = bk
'set focus on bookmarked record
Forms!frmInstallationoutlook.sfrmDataEntrySummaryView.SetFocus
Does anyone have an inckling as to why this may have stopped working or is there another way I can bookmark?
Thanks