<div>
rs(strFieldName1) = Mid(strNewData, InStr(strNewData, &quot;,&quot;) + 1)<br />
<br />
I also found this :<br />
&nbsp; &nbsp; &nbsp; &nbsp; rs(strFieldName1) = Right(Trim([strNewData]), Len(Trim([strNewData])) - InStr(1, [strNewData], &quot;&nbsp;&quot;))<br />
<br />
<br />
I am getting Item not found in this collection:<br />
<br />
Yes, I am set the variables.<br />
&nbsp; &nbsp; Dim rs As DAO.Recordset<br />
&nbsp; &nbsp; Dim strFieldName As String<br />
&nbsp; &nbsp; Dim strFieldName1 As String<br />
<br />
K
</div>


<div>
thanks that did the trick - I figured out the issue of item not found - I forgot to set the value for the 2nd strFieldName1.<br />
<br />
K
</div>


<div>
<div class="content wysiwyg-content">
How do I change this to return the values after the comma?<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; rs(strFieldName) = Left(strNewData, InStr(strNewData, &quot;,&quot;) - 1)<br />
k
</div>
</div>


How do I change this to return the values after the comma?

        rs(strFieldName) = Left(strNewData, InStr(strNewData, ",") - 1)
k

Here is an easy 500 points- return name after comma &amp; stop

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.

Here is an easy 500 points- return name after comma &amp; stop

Here is an easy 500 points- return name after comma & stop