1 Form, 2 Records.....

[dbdubb]

Hello,
I'm curious as to if I can use 1 Form to pass 2 Records into the same table database. For example, if my form collects txtPlayer1 and txtPlayer2 fields, how can I tell it to insert txtPlayer1 into the "Name" field of the database, then tell it txtPlayer2 into the "Name" field of the database? After writing this I feel like it should be the same procedure but I'm not sure.

Any help is greatly appreciated!!
Thanks!

 

[DotNetGnat]

sql1= "Insert Into mytable (Name) values ('"&txtPlayer1&"')"
sql2= "Insert Into mytable (Name) values ('"&txtPlayer2&"')"

conn.execute (sql1)
conn.execute (sql2)

-DNG

 

[dbdubb]

Thanks!!

 

[DotNetGnat]

no problem...glad to help.

-DNG