<div>
Incidentally, there will be one or more record related to MemberID. &nbsp;I want all of them to be inserted into the temporary table.
</div>


Incidentally, there will be one or more record related to MemberID.  I want all of them to be inserted into the temporary table.

<div>
Unreal. &nbsp;That worked. &nbsp;But I wonder why the make table query didn't bring over all of the characters in the memo field????<br />
<br />
Thanks MUCH!!!
</div>


Unreal.  That worked.  But I wonder why the make table query didn't bring over all of the characters in the memo field????

Thanks MUCH!!!

<div>
<div class="content wysiwyg-content">
Using VBA code I want to insert records into a temporary table named &quot;tblTempRunningNotes&quot;. &nbsp;I want the records that get written to this table to come from another table named &quot;tblMemberRunningNotes&quot;. &nbsp;But I only want the records using Forms!frmFormName!txtMembe<wbr />rID. &nbsp;(MemberID is the field in the source table.<br />
<br />
I tried this with an make table query but am not pleased with the results because a memo field contents cut off at 255 characters so I'm hoping INSERT code will work better.<br />
<br />
--Steve
</div>
</div>


Using VBA code I want to insert records into a temporary table named "tblTempRunningNotes".  I want the records that get written to this table to come from another table named "tblMemberRunningNotes".  But I only want the records using Forms!frmFormName!txtMemberID.  (MemberID is the field in the source table.

I tried this with an make table query but am not pleased with the results because a memo field contents cut off at 255 characters so I'm hoping INSERT code will work better.

--Steve

INSERT into table 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.