How to clear a user input form without it automatically saving to your table

[RussellDeano]

Good morning,

I have a user input form on my database however i have noticed if a user starts to make an entry but then stops for some reason and closes the form. The data they have entered already appears on my table (and leaves me with incomplete entries).

Is there a way to prevent this from automatically populating in my table unless the "Save" button is clicked?. I also added a "New Entry" button hoping this would work by refreshing the form but again it seems as soon as a field on the form is populated it then appears in my table.

I am new to access and have no coding on my form (simply because i haven't learnt it yet)

Any help would be appreciated.

 

[Minty]

There are a few methods you can employ here, some are more complicated than others.

One of the simplest ways is to remove any method of closing the form without either completing the record or deleting the incomplete record. You would use the before update property of the form for checking this. Effectively you Cancel the changes made then close the form.

This post links to some great examples https://www.access-programmers.co.uk/forums/showpost.php?p=477067&postcount=7

 

[RussellDeano]

There are a few methods you can employ here, some are more complicated than others.

One of the simplest ways is to remove any method of closing the form without either completing the record or deleting the incomplete record. You would use the before update property of the form for checking this. Effectively you Cancel the changes made then close the form.



Thank you very much for your response, i have followed the link and read the thread but the file is now out of date and will not allow me to open it on the new access, therefore i cannot see what actual steps were taken to solve the problem. I don't suppose you have any other suggestions do you?

Thank you again

 

[Minty]

Hi - I have converted it to Accdb format. See the attached.

 

[RussellDeano]

Hi - I have converted it to Accdb format. See the attached.

Extremely helpful thank you!