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"![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Exit Sub
Else
DoCmd.GoToControl ("Case_number"![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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