If I wanted to make the values in "x" field to be greater than the values in "y" field. How would I write that?
Thanks
If I wanted to make the values in "x" field to be greater than the values in "y" field. How would I write that?
Thanks
You wouldn't put it in the validation rule field,
youd have a 'save' button to validate the fields.
Code:sub btnSave_click() select case true Case txtBox1<txtBox2 MsgBox "bad fields" case isNull (cboBox ) MsgBox "you must select a city" case else Docmd.close Ens select End sub