Hi all!
If someone wanted to add data to multiple fields
in diffrent tables how would that be done?
Can multiple recordsets be open at once?

'Say if i have
Set db = OpenDatabase("C:\whateverpath")
Set rs = db.OpenRecordset("Account Information")

' And then i want to add information to the recordset
' base on what the user entered into the control.

rs.Fields("Account Name") = frmAccountSetup.ctrlAccountName.Text
rs.Fields("Account Address") = frmAccountSetup.ctrlAccountAddress.Text
rs.Fields("Phone Number") = frmAccountSetup.ctrlPhoneNumber.Text
rs.Fields("Account ID") = frmAccountSetup.ctrlAccountID.Text

Thanks all....
'all of the information entered into the controls gets saved into the coresponding fields but Driver id in in another table so i end up getting a run time error item
not found in this collection 3265. So i guess what i getting at is. Is there a way to add data to fields with
the same name in diffrent tables. So i can just open one recordset and close one recordset.


rs.Fields("Driver ID") = frmAccountSetup.ctrlDriverID.Text