im adding an applicant number like this APP-0001 what will i do to automaically add like that
VB Code:
  1. With tbInquiry
  2.       If .RecordCount = 0 Then
  3.         txtAppID = "00000001"
  4.  
  5.     Else
  6.         .MoveLast
  7.         txtAppID = .Fields(0) + 1
  8. '        txtAppInfo(0).SetFocus
  9.     End If
  10. End With
  11. End Sub