Bound/unbound forms

[kingz2000]

Hi everyone,

I currently have a form bound to a table. I have created a save button, because I need to set a flag when I save a dataset. To be more precise I need to add the user to a column of the dataset. So I want to disable the automatic save procedure of saving in a bound form. I tried to set cancel=true in the before_update(), but that creates another problem, that a line from.dirty = false which I had to set before my SQL execution is causing an error(2101).
The question is, is it easy to stop the automatic saving?? If so, how?

 

[combo]

If the table is local - can data macro complete this task?

combo

 

[dhookom]

You could create a local data entry table for temporary storage of the record. When the save button is clicked, the record is appended to the permanent table with the user field. You can also delete the record from the temporary table.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016