setting a reocord set

[shaz123]

Is ti pssible to set more then one recordset at a time

for e.g below one record is set
Set rs = db.OpenRecordset("tbl_TransactionMaster")

Could this be changed to more then one:


Set rs = db.OpenRecordset("tbl_TransactionMaster and AberdeenWoLines")

Is that possible, as i am trying to pass information into more then one table

 

[pbaldy]

I don't think you can do that, but you can set the recordset to an SQL statement that includes both tables. Whether the resulting recordset will be updatable is another matter. Here's what to watch out for:

http://support.microsoft.com/default.aspx?scid=kb;en-us;328828

 

[gemma-the-husky]

you can have two distinct recordsets

set rs1 = recordset1
set rs2 = recordset2

and do what you want with them - is this appropriate

note that one of the suggested solutions by Microsoft for poor fe be performance in a multi user dbs is to open and maintain a permanent link to the be, either with a hidden form bound to a dummy table, or a permanent recordset connection to the dummy table. Hence multiple rst's are not a problem.