How do I stop my form automatically adding a record?.
I want my form to check that 2 figures are the same before adding the record.
I tried adding an after_update procedure that checks the check number with a calculated control figure, if the 2 are the same then then a save record button appears. If the 2 numbers are not the same then a message appears giving up the option to fix a keying mistake or cancel adding the new record.
The procedure does bring up the save record button but it has already updated the record and it is displaying the next blank record.
I want my form to check that 2 figures are the same before adding the record.
I tried adding an after_update procedure that checks the check number with a calculated control figure, if the 2 are the same then then a save record button appears. If the 2 numbers are not the same then a message appears giving up the option to fix a keying mistake or cancel adding the new record.
The procedure does bring up the save record button but it has already updated the record and it is displaying the next blank record.