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.