J
Janet
I am using access 2003. I have a access database that was access 97 and did
convert it. However I was getting this message when I press a button on a
form that has a subform before the conversion.
On the form you select the record you want to open then click the open
record button. I get the error on the click of this button.
I did a search for this problem before I posted and am supprised nothing
came up. Has anyone else had an issue like this? if so how did you fix it?
Code looks like this:
Private Sub ExpenseReport_Click()
On Error GoTo Err_ExpenseReport_Click
If IsNull(Me![EmployeeID]) Then
MsgBox "Enter employee before entering expense report."
Else
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OpenForm "Expense Reports"
End If
Exit_ExpenseReport_Click:
Exit Sub
Err_ExpenseReport_Click:
MsgBox Err.Description
Resume Exit_ExpenseReport_Click
End Sub
convert it. However I was getting this message when I press a button on a
form that has a subform before the conversion.
On the form you select the record you want to open then click the open
record button. I get the error on the click of this button.
I did a search for this problem before I posted and am supprised nothing
came up. Has anyone else had an issue like this? if so how did you fix it?
Code looks like this:
Private Sub ExpenseReport_Click()
On Error GoTo Err_ExpenseReport_Click
If IsNull(Me![EmployeeID]) Then
MsgBox "Enter employee before entering expense report."
Else
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OpenForm "Expense Reports"
End If
Exit_ExpenseReport_Click:
Exit Sub
Err_ExpenseReport_Click:
MsgBox Err.Description
Resume Exit_ExpenseReport_Click
End Sub