A very simple question

[mkkashif]

i only want if first condition meet then stop the user at that point not go further postion.
not check other condition .
what i have write with first endif.
code
If IsNull(Me.total) Then
MsgBox "You Can Not Enter Bill Without Any Products", vbInformation
End If

If Me.text.Value = "Sale" Then

If MsgBox("You Are Going to Update All Things Cofirm to Yes or No to Return", vbQuestion + vbYesNo, "Save Record?") = vbYes Then
DoCmd.OpenQuery "insertdaybook"
DoCmd.OpenQuery "insertstock"
DoCmd.OpenQuery "updatestock"
End If
'donothing
End If

 

[Štef1]

Hello Mkkashif!
Before the first "End If" write Exit Sub

 

[KenHigg]

If IsNull(Me.total) Then
    MsgBox "You Can Not Enter Bill Without Any Products", vbInformation
Else
    If Me.text.Value = "Sale" Then
        If MsgBox("You Are Going to Update All Things Cofirm to Yes or No to   Return", vbQuestion + vbYesNo, "Save Record?") = vbYes Then
           DoCmd.OpenQuery "insertdaybook"
           DoCmd.OpenQuery "insertstock"
           DoCmd.OpenQuery "updatestock"
        End If
    End if     
End If

???
kh

 

[mkkashif]

thanks

thanks it's working