Private Sub SvnNew_Click() If [Forms]![Issue]![Issue_Qntty] < [Forms]![Issue]![INStock] Then DoCmd.SetWarnings False DoCmd.OpenQuery "updateqry", acViewNormal, acEdit DoCmd.SetWarnings True DoCmd.Save MsgBox ("saved sucessful") DoCmd.Close acDefault DoCmd.OpenForm "Issue", acNormal 'ElseIf [Forms]![Issue]![Issue_Qntty] > [Forms]![Issue]![INStock] Then 'MsgBox ("invalid value") Else MsgBox ("invalid value") End If End Sub
Issue_Qntty
INStock
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)