<div>
Yep that worked. &nbsp;Thanks capricorn!
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
This question is related to a previous question I asked.<br />
<br />
<a href="https://www.experts-exchange.com/questions/27031414/MS-Access-Forms-How-to-detect-if-data-in-field-has-changed.html" rel="ugc">http://www.experts-exchang<wbr />e.com/Micr<wbr />osoft/Appl<wbr />ications/Q<wbr />_27031414.<wbr />html</a><br />
<br />
When I'm checking my old value against the new value to see if it changed, when the old value is NULL it doesn't detect a change. &nbsp;<br />
<br />
Example: <br />

<pre><code id="code-10-27034093-1">If g_User_Task = &quot;ReviseOrder&quot; Then
        If Me.cboUDStakePockets.OldValue &lt;&gt; Me.cboUDStakePockets.Value Then
            Me.cboUDStakePockets.Value = Me.cboUDStakePockets.Value &amp; &quot; CHANGED&quot;
        End If
    End If</code></pre>
<br />
So when the user opens the form and makes a selection from a combo box that was previously empty, the .oldvalue comes up as NULL and it doesn't detect a change. &nbsp;Is there a way around this? &nbsp;
</div>
</div>


Hello,
This question is related to a previous question I asked.

http://www.experts-exchange.com/Microsoft/Applications/Q_27031414.html (https://www.experts-exchange.com/questions/27031414/MS-Access-Forms-How-to-detect-if-data-in-field-has-changed.html)

When I'm checking my old value against the new value to see if it changed, when the old value is NULL it doesn't detect a change.  

Example: 
(CODE)

So when the user opens the form and makes a selection from a combo box that was previously empty, the .oldvalue comes up as NULL and it doesn't detect a change.  Is there a way around this?  

MS Access VBA Forms

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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.