Numerous Entries to a textbox

[Brutuss]

I have a "Notes" section on my main form. Notes can be typed manually, or pre-formatted note entries can be entered by calling up a sub form, selecting a note from a drop-down list and it automatically inserts. The only problem is my drop-down list will only enter one selection. If I need more than one, it overwrites whatever is already in the box. How can I select a note, and then after it inserts select a second note and have it insert behind the first one and so forth? Here is my AfterUpdate event:

Private Sub Notes_AfterUpdate()

Forms![Purchase Order Data].GeneralNotes.Value = Notes.Value
DoCmd.Close
End Sub

Thanks!

 

[boblarson]

I will give you the same suggestion I make to everyone who wants to do this. DON'T DO IT. Create a notes table and use a subform to be able to add DISCRETE notes. You will find it much easier to work with later and to bring back data. Appending to the same field basically will render everything useless in trying to find what you want when someone asks you to find something.

 

[Brutuss]

The notes entered manually by hand "store and recall" with the records just fine, and have for 5 years. They also inseert into the order form just fine when it is generated. All I am looking for is a much simpler way of entering the notes, especially for repetitive entries without having to constantly do it by hand. These are not notes for in-house, but instructional notes for clients on their order form.

 

[boblarson]

Just because a bad design has been working for 5 years doesn't make it a good design.

you can append to a field by using something like:

Me.YourMemoFieldnameHere = Me.YourMemoFieldNameHere & vbCrLf & Me.YourControlWithNewTextHere

 

[Brutuss]

The notes are stored with the records and recall just fine. I need a way to make the task easier - especially for the repetitive [and sometimes long] entries. These are NOT in-house discreet notes, they are instructions for customers that are eventually inserted on the order form. Everything works just fine, I just need to make the function insert "selection after selection" continuously in the notes box.