save user input from a textbox to a secondary textbox

[mcv110]

I have created a form to track inventory assets, the form was built from TblInventory. On the form is a textbox that I would like to use to save user input on changes to a specific asset.

Is it possible to have the user type notes into the TxtNotes box, then save those notes into the TxtNotesHistory text box? As new notes are added I would like to keep old notes and append to the top, and I would really like to automatically prepend the date to each entry added.

The TxtNotesHistory and TxtNotes text boxes are not bound to any record in the table.

I have just learned of the SaveInput function and have also looked into creating a public sub with something like this - Public Sub RunImportProcedure(ByVal TxtNotes As String) which I think will capture the input of TxtNotes...though I am pretty green with Access and even less familiar with using almost any of the VBA elements.

Thanks for any input. I have included a screenshot of the text boxes in question. Essentially I want to save that user input value of "test" in the History text box to the right of the Notes textbox.

[mcv110]

It occurs to me that the entries here should be bound to each piece of equipment. My TblInventory has a record for each piece of equipment, and I would like the notes section to reflect each individual record. Perhaps I have missed assigning some relation for the input and the record it belongs to

[Micron]

My advice would be to make each note a new record. By appending, you have no way of associating added notes with the entry date, the db user who input the notes, thus such details will not be searchable (i.e. notes between or on a date / by a user). You will have to use code to append to existing notes, or just let people click into the field and start typing. That's a good way to lose everything that was entered before, which means the entire notes history as well.

[Welshgasman]

I'd expect you would use an append query.

[mcv110]

yeah that actually makes a lot of sense. I guess I just assumed there would be a simple VBA function I could run.

[Micron]

Don't know whose reply that pertains to, but yes, it would be fairly simple to capture the existing text and append to it. It's just something that provides a whole lot of flexibility. In your form, you'd 'lock' the control that shows the existing comment and have an unbound control from which you'd concatenate (not append) the additional text. If this will be a short text field, you're limited to 255 characters. If you make it a memo (long text) field, you can introduce problems such as returning Asian like characters in query results and not being able to join the memo field in any query. You also cannot do other thing such as index the field (not that you'd likely want to index a comment field). All around, the idea of concatenating notes would be a non-starter for me - unless you were a paying customer who chose not to heed the advice.

[mcv110]

I'd expect you would use an append query.

yeah that actually makes a lot of sense. I guess I just assumed there would be a simple VBA function I could run.