<div>
If TargetShare is text, then:<br />
<br />
CurrentDb.Execute &quot;UPDATE tblGoals SET TargetShare = &quot;&nbsp;&amp; Chr(34) &amp;&nbsp;Me.TargetShare &amp;&nbsp;Chr(34) &amp;&nbsp;&quot; where Crop_ID = &quot;&nbsp;&amp; Me.CurrentCrop &amp;&nbsp;&quot; And Location_ID = &quot;&nbsp;&amp; Me.CurrentLocation<br />
<br />
<br />
<br />
<br />
<br />
&nbsp;
</div>


If TargetShare is text, then:

CurrentDb.Execute "UPDATE tblGoals SET TargetShare = " & Chr(34) & Me.TargetShare & Chr(34) & " where Crop_ID = " & Me.CurrentCrop & " And Location_ID = " & Me.CurrentLocation





 

<div>
Is any of below fields a character type?<br />
TargetShare <br />
Crop_ID<br />
Location_ID
</div>


Is any of below fields a character type?
TargetShare
Crop_ID
Location_ID

<div>
<div class="content wysiwyg-content">
I really struggle with these situations where I need to use &quot;&nbsp;or '. The line below is giving me a type mismatch error. Both variables are numeric. Where am I going wrong?<br />
<br />
CurrentDb.Execute &quot;UPDATE tblGoals SET TargetShare = &quot;&nbsp;&amp; Me.TargetShare &amp;&nbsp;&quot; where Crop_ID = &quot;&nbsp;&amp; Me.CurrentCrop And Location_ID = &quot;&nbsp;&amp; Me.CurrentLocation &amp;&quot;
</div>
</div>


I really struggle with these situations where I need to use " or '. The line below is giving me a type mismatch error. Both variables are numeric. Where am I going wrong?

CurrentDb.Execute "UPDATE tblGoals SET TargetShare = " & Me.TargetShare & " where Crop_ID = " & Me.CurrentCrop And Location_ID = " & Me.CurrentLocation &"

Type Mismatch must by syntax

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.