reaktorblue
Board Regular
- Joined
- Aug 8, 2007
- Messages
- 87
- Office Version
- 365
- Platform
- Windows
I have the below code on frmDashboard. When I click on cmdAddEmployee, I'm directed to frmAddEmployee and when finished and close, frmDashboard updates the list of Employees and goes to the latest record.
The below code works however, I've noticed an issue that when exiting out of this database, msaccess.exe is still running. I have to consistently end that task and then I can reopen the database successfully.
I've commented the below code out and then did not experience the issue above with msaccess.exe still running. Is there something wrong with my code below?
The below code works however, I've noticed an issue that when exiting out of this database, msaccess.exe is still running. I have to consistently end that task and then I can reopen the database successfully.
I've commented the below code out and then did not experience the issue above with msaccess.exe still running. Is there something wrong with my code below?
Code:
Private Sub Form_Activate()
'Refresh Employees displayed on Dashboard form by Last Record
Dim rs As Recordset
If DCount("*", "qryDashboardEmployees", [ID]) > 0 Then
DoCmd.Requery
Set rs = Me.RecordsetClone
rs.FindFirst "id=dmax('ID', 'tblEmployees')"
Me.Bookmark = rs.Bookmark
End If
End Sub