Update 2nd table from text

[Bob]

Hello

I am using text boxes and combo boxes on my form. I would like to be
able to update a second table from the boxes in the first.

On my main form with adodc these are update to DB1

Combo1(8) = Equipment
Combo1(9) = Make
Text1(20) = Model
Combo1(10) = Serial

At the same time I want them to update in db 2

Equipment = Combo1(8)
Make = Combo1(9)
Model = Text1(20)
Serial = Combo1(10)

Thanks
Bob

[Pieter Linden]

Re: Update 2nd table from text

Umm... so create a connection to db2, then use the cnn.Execute strSQL
statement or something. Or use a command object... you might wanna
find a comfy chair and read through the ADO documentation.. .