Guest_imported
New member
- Jan 1, 1970
- 0
hi, again
i got some coding here which is using for searhing the case number ( primary key in my db). i suppose to put several line of code which can display message when can't find searhing number. help!!
thanks.
Private Sub GoBtn_Click()
Dim CaseNum As String
Dim digit As String
If IsNull(Forms!frmCases_pages!FindCaseNo) Then
DoCmd.CancelEvent
MsgBox "You Have Not Entered a Case Number!", [vbOKOnly]
DoCmd.GoToControl ("FindCaseNo"
Exit Sub
Else
DoCmd.GoToControl ("Case_number"
DoCmd.FindRecord CaseNum, , True, , True
End If
i got some coding here which is using for searhing the case number ( primary key in my db). i suppose to put several line of code which can display message when can't find searhing number. help!!
thanks.
Private Sub GoBtn_Click()
Dim CaseNum As String
Dim digit As String
If IsNull(Forms!frmCases_pages!FindCaseNo) Then
DoCmd.CancelEvent
MsgBox "You Have Not Entered a Case Number!", [vbOKOnly]
DoCmd.GoToControl ("FindCaseNo"

Exit Sub
Else
DoCmd.GoToControl ("Case_number"

DoCmd.FindRecord CaseNum, , True, , True
End If