I am working with Access 97. I have a subform(continuous form) which has 4 data entry fields. If the user starts entering a record, then deletes all the data in the 4 fields I don't want to save the record.
In the BeforeUpdate event of the subform I have code to check for null values in all the fields and if so, cancel = true and go exit_form_beforeupdate. Well, it doesn't update the record, but I can't get out of the beforeupdate event or even set the focus on the main form.
I'm sure this is something ridiculous, but I just can't figure it out.
Any help is greatly appreciated.
In the BeforeUpdate event of the subform I have code to check for null values in all the fields and if so, cancel = true and go exit_form_beforeupdate. Well, it doesn't update the record, but I can't get out of the beforeupdate event or even set the focus on the main form.
I'm sure this is something ridiculous, but I just can't figure it out.
Any help is greatly appreciated.
