hi
access 16, have several text box (ID, CIR, Name) in a form with a save btn..
if when input a CIR that already exist then below display added the code in before_update..
how to amend it that when click on yes it goes to next text box i.e name
when click on no.. it clear the text box CIR
Dim varCIR As Variant
varCIR = MsgBox("exist. Do you want to continue? ", vbYesNo, "Close Confirmation")
Select Case varCIR
Case vbYes
<<< allow cir entry and goes to next text box>>
Case vbNo
Cancel = True
<<< clear text box CIR>>
Exit Sub
End Select
access 16, have several text box (ID, CIR, Name) in a form with a save btn..
if when input a CIR that already exist then below display added the code in before_update..
how to amend it that when click on yes it goes to next text box i.e name
when click on no.. it clear the text box CIR
Dim varCIR As Variant
varCIR = MsgBox("exist. Do you want to continue? ", vbYesNo, "Close Confirmation")
Select Case varCIR
Case vbYes
<<< allow cir entry and goes to next text box>>
Case vbNo
Cancel = True
<<< clear text box CIR>>
Exit Sub
End Select