Autogenerating pieces of text in a note or comment field

[Gary Childress]

Is it possible to autofill a note or comment field in a form based on what I select in a separate form lookup field? For example if I choose the "interaction number 1", then I want it to start off a long text field with "Talked to the client in person". What I would like to do is create a form that when I click on the "interaction number" then I can fill in the rest of the note field with more details but I want the note field to always start out with the type of interaction that I had. It would also help if I could add pieces of text to a note or comment field based on clicking elsewhere in the form. In other words I want to autogenerate comment notes based on some basic data and then leave the rest of the field open so that I can add notes that I can't autogenerate. Is that doable in access?



Many thanks!

[ranman256]

make a table to hold your 'phrases'.
add a combo box near the comment box bound to this table,
then you can pick the phrase (usu with the 1st letter of the phrase), then click ADD btn to append it to the txtComment box. save typing.

and you add a Default (y/n) field to the t.phrase table,
this would auto add the phrase to the comments when you add a record. ON CURRENT event.

[Gary Childress]

Hi, ranman256. Thanks for the reply. Can you elaborate on how to create an "ADD btn" to append the phrases to the text comment box? Also can you elaborate on the last part, adding a default y/n button to the t.phrase table? How do set up a current event to add the comments?

Thanks!

[DMT Dave]

If I am correct, i think ranman256 suggestion is to Add a table with 3 fields perhaps called:

ID as Text field (1st letter or similar)
Phrase as Text field or Long Text Field dependant on the size of Phrase
Added as Yes/No field (confirms phrases added or not)

Add Combo box bound to the table with 3 columns, column widths only need to show ID field

ID is column (0)
Phrase is column (1)
Added is Column (2)

After Update

Me.txtComments = Me.Combo.Column(1) Phrase is now in Text Box Comments

If this is a one time event then Set a Recordset

.Edit
!Added = Yes /True
.Update

I hope i have given correct information as I frequently get stuck myself and all people on this forum are very good and advising methods that works and much more knowledge