-
Hi, Is it possible for a textbox to have info typed into it and then when the user clicks ok it goes to 2 different tables with the same info? And if so, When i go to edit will it update both tables with the similar fields. Its just that i am getting an error because 1 table has taken over the textbox and wont let it go. If not, Is there some way to do this?
Thanx in Advance
Mike
-
Hi,
Yes it is possible, but you need two recordsets.
open both recordsets and point them to the two different tables, then
rs1.edit or rs1.addnew
rs1.field = text1.text
rs1.update
rs2.edit or rs2.addnew
rs2.field = text1.text
rs2.update
HTH,
Preeti
