<div>
Make sure you have no compile errors and no missing references.
</div>


Make sure you have no compile errors and no missing references.

<div>
If I was missing a reference, why would it work on another form in the same database?
</div>


If I was missing a reference, why would it work on another form in the same database?

<div>
Missing references cause errors that almost always have nothing to do with anything. &nbsp;Usually, it is the first piece of code that is executed that raises the error. &nbsp;So, you might get an error telling you that the Date() function is invalid if that code is executed first.
</div>


Missing references cause errors that almost always have nothing to do with anything.  Usually, it is the first piece of code that is executed that raises the error.  So, you might get an error telling you that the Date() function is invalid if that code is executed first.

<div>
Because it turned out to be a bizarre bug that few if any could have suggested.
</div>


Because it turned out to be a bizarre bug that few if any could have suggested.

<div>
<div class="content wysiwyg-content">
I am calling an event written in VBA from a button on a form in Access. &nbsp;I have the almost IDENTICAL code on another form (I changed the variable and query names, that is IT) that is working just fine. &nbsp;However, I keep getting the attached error when I try to run it from my new form.<br />
<br />
Any ideas?<a href="https://filedb.experts-exchange.com/incoming/2014/11_w46/882713/acxerror.png" target="_blank" title="Access error message. (433 KB)"><img alt="Access error message." class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/11_w46/800_882713/acxerror.png" /></a>
</div>
</div>


acxerror.png

I am calling an event written in VBA from a button on a form in Access.  I have the almost IDENTICAL code on another form (I changed the variable and query names, that is IT) that is working just fine.  However, I keep getting the attached error when I try to run it from my new form.

Any ideas?

MS Access ActiveX Error

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.