This is probably quite simple but looking for some guidance. This code works fine and just cancels a given action if the user presses No on the msgbox:
If MsgBox("This quotation will be cancelled and you will be unable to convert it to an an order, nor will it appear on the quotations list. Do you want to continue?", vbQuestion + vbYesNo, "GBIS") = vbYes Then
Me.orderstatus.Value = "Cancelled"
MsgBox "This quotation has been cancelled. This screen will now close.", vbInformation, "GBIS"
I want to add something like:
if vbno then me.textbox.value = ""
Just to clear out a text box and abort the actions which are taken when yes is pressed.
All help appreciated.