I have a Table(PA Phrases) consisting of phrases to be used in a purchase agreement, but not all phrases apply for every purchase agreement. I want to allow the sales rep to select the phrases desired from a form, and then have a VBA or access query take all the phrases and concatenate them into a single paragraph style string, and put that string into another field in another table or at least into a text box on the form. I need to know what commands to use in VBA to pull from the PA phrases table and how to write to another Table or text box. I plan to use a count loop to search my PA phrases table and only pull from rows with a "yes" in the checked field, but I just don't know vba to pull the table in and write it out. once i link it in vba, i believe i can get the rest working.
1
