Search results

Thanks, that helped. I determined that I kept on trying to match a string in the table where it was an integer. Here is the final working code for reference: Private Sub cmdSubmit_Click() Dim strUpdateSQL As String With Me strUpdateSQL = _ " UPDATE tblDevelop SET " & _ " [CustName]...

Thanks, I am using the provided syntax but it is still throwing a syntax error. I've been battling this for about 3 days. :confused: Here is the code, any clues. Private Sub cmdSubmit_Click() Dim strUpdateSQL As String With Me strUpdateSQL = _ " UPDATE tblDevelop SET " & _ " [CustName]...

I appreciate the response. Is it not possible to use an insert query when there is already data in the table? As for the update query, can you give me an example of how I would use the syntax with the code i have?

Ok, I've cleaned everything up with some direction, here is what I have now. Problem remains the same when the code is called it throws a syntax errror: Private Sub cmdSubmit_Click() Dim strInsertSQL As String With Me strInsertSQL = ("UPDATE tblDevelop [CustName], [Q1S], [Q2S], [Q3S]...

To give a little background, I have a form that initially inserts data into table on submit. I have a second form that pulls from the table and repopulates the form fields for editing purposes. I want to be able to update the table on submit of this form. My query syntax seems to be a little...