Add function to bound form field?

[arothacker]

I have a form called "Backfill" that submits the data to a table called "Updated Headcount"

On the form there is an ID textbox that is unbound and a Notes textbox that is bound to the Notes field in Updated Headcount.


When the user types a value in the ID textbox, I want to concatenate "backfill" and the ID value to the Notes textbox. I then want that concatenation to submit to the Notes field in the table.

I've tried putting ="Backfill" & ":" & [ID] in the before and after update but nothing works. I can't put it directly in the Notes textbox because then it becomes unbound.

Any thoughts??

[pbaldy]

How about

Me.NotesTextbox = Me.NotesTextbox & " Backfill" & ":" & [ID]

[arothacker]

I actually figured it out right after I posted this! Haha I was putting the expression in the after update of the Notes field rather than the ID field.

When I put in the After Update of the ID unbound textbox:
Me.Notes= "Backfill" & ":" & Me.ID

Then it worked! Thanks though!

[pbaldy]

Glad you got it sorted. You're okay with that overwriting anything that might already be present in the notes textbox?

[arothacker]

Based on what the form is used for there shouldn't be anything in the Notes section because it will be a new entry. Thanks for checking though!