INSERT INTO Help Needed

[Randy]

CurrentDb.Execute "INSERT INTO Accountlist" & "(CustEmailAddress) VALUES ('CustomerEmail');" --- After Update Event.


I am trying to update the Accountlist table field 'CustEmailAddress' with information entered into the field CustomerEmail on a form named Delivery.
Any help will be greatly appreciated.

Thank you,
Randy

[June7]

Why doesn't it work, what happens - error message, wrong results, nothing?

The concatenation is incorrect if CustomerEmail is a textbox on form.

CurrentDb.Execute "INSERT INTO Accountlist (CustEmailAddress) VALUES ('" & Me.CustomerEmail & "');"

[Randy]

There wasn't any error message it just tabbed to the next control. I tried your code and it works perfectly, thank you. I do still have an issue though. On the form Delivery I use a combo box to lookup a record from the table Accountlist. I want to update the email address for the record in table Accountlist that is selected by the combo box on the form Delivery. On the form Delivery the CustID (from Accountlist) is in the TextBox CustomerID and the name of the table Accountlist field is CustID. I hope this isn't too confusing. Thank you for your help.

[June7]

That would be an UPDATE sql action.

CurrentDb.Execute "UPDATE Accountlist SET CustEmailAddress='" & Me.CustomerEmail & "' WHERE CustID=" & Me.CustomerID

[Randy]

Thank you so much June7... that is exactly what I needed.