Hey guys, Currently undertaking a placement and have a ridiculous data entry task which involves copy & pasting data across numerous lines in a form. I'm trying to make a button to try speed this up and have little to no knowledge of databases... This is in Access. There is a table of parts which apply to a range of models, my task is assigning times to each model for a given part. Currently I must manually enter the times for each model despite 90% of parts having the same time for each model. I have added the button and here is the code I have made. =============================================================================== Private Sub btnCopyTimes_Click() ' Define variables Dim EnteredValue As Double Dim IDToUpdate As String Dim strSQL As String ' Grab ID on form IDToUpdate = Me.FINLDATA_ID.Value ' Prompt for new base time for ALL models EnteredValue = InputBox("Enter New Base Time for ALL models") ' Update table with new base time for ALL models with specific ID strSQL = UPDATE FINLDATA MODELS SET BASE TIME = EnteredValue WHERE FINLDATA MODELS.FINLDATA_ID = IDToUpdate RunSQL strSQL End Sub =============================================================================== It's not happy with the Update statement and I have no doubt I've butchered it but unsure where to start... If you have any questions I'll try answer.