Hi,
I'm afraid you have to place all that condition inside the Where clause. You can check the syntax for Update. If you
find that difficult then you can paste your code here for review. Someone may be able to give an alternate solution (SQL
Statement)

Paste your update statement alone here.

Regards

Trevor Benedict R
Software Engineer
Mascot Malaysia Sdn Bhd

| How vb update a table when this table inner join table b
| Table A and Table B are in Different Access Database file.
| table A.Co = Table B.ID, Set Table A.Remark = New
|
|
| Private Sub Form_Load()
| conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & _
|             "\A.mdb;Persist Security Info=False"
| Set objRe = New ADODB.Recordset
| conString1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & _
|             "\B.mdb;Persist Security Info=False"
| Set objUpd = New ADODB.Recordset
|
| End Sub
|
| -------------------------------------------------
| Private Sub UpdateDB_Click()
| With objUpd
| If .State = adStateOpen Then .Close
|     .ActiveConnection = conString1
|     .Source = "UPDATE A INNER JOIN B ON A.co = B.id SET A.remark = "new"
|
|     .Open
| End With
| End Sub
|

|
| thank you
|
|