Is it possible to add a value to an existing record

[smiler2505]

Sub cmbENum_AfterUpdate()
 
DoCmd.RunSQL "INSERT INTO tblExa(CCanEnt) SELECT tblCwS.CCanEnt FROM tblCwS WHERE tblCwS.ENum = tblExa.ENum"
 
End Sub
 

Tried that, without success.
When I change the value ENum in a combo box, I want it to take the value of CCanEnt from the same record, and add it to an existing record in another table.

[Lysander]

Sub cmbENum_AfterUpdate()
 
DoCmd.RunSQL "INSERT INTO tblExa(CCanEnt) SELECT tblCwS.CCanEnt FROM tblCwS WHERE tblCwS.ENum = tblExa.ENum"
 
End Sub
 

Tried that, without success.
When I change the value ENum in a combo box, I want it to take the value of CCanEnt from the same record, and add it to an existing record in another table.

Your code is picking up ENum from the table, not the form. If you have not saved your record, then the value of ENum from the combo box is not the same as Enum in the table. Try changing your WHERE clause to
WHERE tblCwS.ENum=" & cmbENum

[smiler2505]

 DoCmd.RunSQL "INSERT INTO tblExa(CCanEnt) SELECT " & txtCCanENt & " FROM tblCwS WHERE tblCwS.ENum = " & cmbENum
 

Data type Mismatch In Criteria Expression
Does that mean the value Im trying to insert isn't valid for that field?

[smiler2505]

It's because it's trying to add a whole new record to the table, and I've set tblExa up to not allow duplicate records. I need the value of CCanEnt to add itself to the record where ENum in tblCwS is the same as ENum in tblExa.

[Lysander]

It's because it's trying to add a whole new record to the table, and I've set tblExa up to not allow duplicate records. I need the value of CCanEnt to add itself to the record where ENum in tblCwS is the same as ENum in tblExa.

Instead of insert, you want update, like this

DoCmd.RunSQL "UPDATE  tblCwS SET CCanEnt='" & txtCCanENt & "' WHERE ENum =" & cmbENum & ";"
 

I'm not sure exactly which table you are trying to update, also, note the apostrophe before and after the quotes to make a string out of txtCCanENt

[smiler2505]

Thanks! working great. You forgot to enclose the second variable in single quotes but it was easy enough to fix