<div>
If the record is saving, chances are that it is complete by the table standards. &nbsp;you could set the fields you need to be required in the table.
</div>


If the record is saving, chances are that it is complete by the table standards.  you could set the fields you need to be required in the table.

<div>
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
Accept question, points to wtf666 <br />
Please leave any comments here within the next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!<br />
<br />
1William<br />
EE Cleanup Volunteer 
</div>


No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, points to wtf666
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

1William
EE Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
I have a Command Button on a form which runs a macro with a single Close satement to close the form. However, if any data has been entered into any of the fields in the form before the button is clicked, the record is saved (even if it is incomplete). I want it to close the form without saving any of the data that has been entered. I know this is probably a fairly simple question, but the solution just escapes me!!!<br />
<br />
Cheers,<br />
<br />
Nick.<br />

</div>
</div>


I have a Command Button on a form which runs a macro with a single Close satement to close the form. However, if any data has been entered into any of the fields in the form before the button is clicked, the record is saved (even if it is incomplete). I want it to close the form without saving any of the data that has been entered. I know this is probably a fairly simple question, but the solution just escapes me!!!

Cheers,

Nick.


Close Form Without Saving Record (Command Button)

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.