Can info in one textbox go to 2 different tables?

[Spawny]

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

[preeti]

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