Hello,
On my Clerk form (password "clerk") when entering an AFR Number that exists can the cursor return to the AFR Number control and have it cleared? Also when trying to exit this form with no entries it goes to debug can there be an error checker added? One AFR Number that exists is '99999'.
Thank you very much for your help,
Bill
Code:Private Sub AFRNumber_BeforeUpdate(Cancel As Integer) If DCount("*", "AFRs", "AFRNumber=" & Me.AFRNumber) > 0 Then MsgBox "This AFR Number already exists please enter another number" End If End Sub