Hello I am trying to find vba code that would allow me to copy the first record of a table but only at a specific field. And then to paste that data to all the other records matching fields.

I am doing this so there can be a digital signiture the user can enter. I want it to be a form "frmReview" where the user just enters the date in "txtReviewDate" and signature in "txtReviewBy" then clicks a button "btnSubmitReview" and the entered values are pasting into all records in "tblReview". The value of "txtReviewDate" pastes to "ReviewDate" field in "tblReview". And the value of "txtReviewBy" pastes to "ReviewBy" Field in "tblReview".

I would use an Update query. You can build it with VBA code and run it.

How will you know which records to update?

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

I dont think I can do an update query because the 2 fields dont have anything in them. It knows what records to update because I have the 2 fields txt box's in the form using the [Add Existing fields property in the form view] So it starts off at record 1 in the "tblReview" and then when I enter the date and signature, it puts that data on the table.

I am trying to use a code or some thing so I dont have to enter in the same date and signature 20-40 times. I want it so when I click the button "btnSubmitReview" it copys the data from the first records 2 fields "ReviewDate" field in "tblReview", "ReviewBy" Field in "tblReview" to all the records.

I played around with the update queries more and got it figured out. Thanks for the help.

Thanks for the update.

Great job figuring it out!

Good luck with your project.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015