Copy data from unbound textbox to a record in a table

[MunroeM]

I have a Update form where the user has to enter a new expiration date and fill in their name when an item returns from being serviced.



I have 2 unbound textboxes one for the new expiration date "NewDate" and one for who updated the record "UpdateBy". I would like to take the data that they have entered in those locations and replace the current expiration date and updated by records. The records i would like to replace are in the Calibrated Items Table "CalItemT" Under the Fields "ExpirationDate" and "UpdatedBy".

On my Update form there is a combobox list where they select the item that is returning and it displays all the info about the Item on the one side and it provides them with the unbound textboes to enter the new expiration date and updated by. I have a button on the bottom that they will click once the info is entered and it will save and close the form.

I have been searching for hours trying to find a way to do this but my google-fu is drained and iv come up empty handed.

Thanks for the help

Munroe

[orange]

Can you show us your tables and relationships as a jpg?
Also, a jpg of your form may be helpful.

[MunroeM]

I have attached a Jpeg Image and my database.

The Green, Red and Blue Boxes and arrows are not actually in the form. I added them with paint.
In the photo I have attached you first select the serial number from the combo box in the blue square. The Combo box has all the items currently sent away for cal. When you select the serial number it shows the data belonging to that serial number in the red box. This ensures the serial number matches the item you received. The Green box has the unbound text boxes and I want the data entered in them to replace the data that the arrows are pointing to. I want that to happen once the save and exit button is pressed.