Pyro
Too busy to comment
- Local time
- Tomorrow, 08:31
- Joined
- Apr 2, 2009
- Messages
- 127
Hi,
I am running the following code from a subform:
However as soon as this error occurs and the message box displays, all combo boxes on the main form and other subforms become locked (i.e. their values can be seen but not selected)
I am running Access 2003.
Any ideas?
I am running the following code from a subform:
Code:
Private Sub Form_Error(DataErr As Integer, Response As Integer)
Debug.Print "Error Number = ", DataErr
Select Case DataErr
Case 3314
MsgBox "There is no course selected for this student." & vbCrLf & _
" " & vbCrLf & _
"Select a course before proceeding.", vbExclamation, "Error"
Me.cmdDelete.SetFocus
Me.Undo
Response = acDataErrContinue
Case Else
Response = acDataErrDisplay
End Select
End Sub
However as soon as this error occurs and the message box displays, all combo boxes on the main form and other subforms become locked (i.e. their values can be seen but not selected)
I am running Access 2003.
Any ideas?