<div>
Also, if you want to return a value from the Msgbox, use an = sign and parens:<br />
<br />
<br />
Something = MsgBox(&quot;You must enter a Part Number&quot;,vbOKCancel) <br />
<br />
Something = MsgBox(&quot;Try Again?&quot;,vbYesNo) <br />
<br />
etc...
</div>


Also, if you want to return a value from the Msgbox, use an = sign and parens:


Something = MsgBox("You must enter a Part Number",vbOKCancel)

Something = MsgBox("Try Again?",vbYesNo)

etc...

<div>
Doh, I knew that! &nbsp;I feel bad now. &nbsp;Thanks Again!
</div>


Doh, I knew that!  I feel bad now.  Thanks Again!

<div>
<div class="content wysiwyg-content">
Why is VB Editor telling me &quot;= expected&quot; from this line of code?<br />
<br />

<pre><code id="code-10-28184902-1"> MsgBox(&quot;You must enter a Part Number&quot;,vbOKOnly)</code></pre>
</div>
</div>


Why is VB Editor telling me "= expected" from this line of code?

(CODE)

Access 2010 VBA Msgbox = expected 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.

Microsoft Access

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.