Hello there! I'm Still pretty new to access only been using it for a
couple of days.
If a record has been partially filled out or even completly filled out
and then the form is closed or the user clicks to view an alternative
record i do not want the values they had typed into that record to be
saved.
I only want the valuse to be saved if the user clicks my save button on
my page.
On my form i have set the control source of each of my textboxes to the
relavent colmn in the table but i dont want these to update the table
untill save is selected.
Is this possible? If not could i do an if statment which said something
like..
If any of the textboxes have not been filled out.
Delete this record altogether
Many thanks in advance