<div>
Don't set the value of the ID. Instead, assign the number as the DefaultValue of the ID. This way, no data are added before the user starts writing.<br />
<br />
/gustav
</div>


<div>
Never, ever dirty a record yourself with code. &nbsp;If you need to populate foreign keys or data fields, do it in the form's BeforeInsert event. &nbsp;That way your code will only run for new records and it will only run after the user has dirtied the record. &nbsp;That prevents &quot;empty&quot; records from being created or the user from getting error messages he doesn't understand because he &quot;knows&quot; that he didn't change anything.<br />
<br />
Or you can use the form's Dirty event but in that case, you MUST check to determine if it is a new record because you don't want to overlay existing data.<br />
If Me.NewRecord = True Then<br />
&nbsp; &nbsp; populate the fields<br />
End If
</div>


<div>
<div class="content wysiwyg-content">
I have a form with a button to add new activity to the current record. In my activity form, I have a field that gets it's case ID from the open form. If a user closes the form, it creates a new record because that field was technically &quot;filled out&quot; with the ID. How do I tell it to not create a new record if nothing changed or was entered?<br />
<br />
Thanks!
</div>
</div>


I have a form with a button to add new activity to the current record. In my activity form, I have a field that gets it's case ID from the open form. If a user closes the form, it creates a new record because that field was technically "filled out" with the ID. How do I tell it to not create a new record if nothing changed or was entered?

Thanks!

Don't save a record if nothing changed (have pre-filled data from another form)?

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.

Microsoft Access

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.