How do you open a recordset where in the table is residing in another MDB file?
J jbkirby via AccessMonster.com Jan 17, 2008 #1 How do you open a recordset where in the table is residing in another MDB file?
J jbkirby via AccessMonster.com Jan 17, 2008 #2 Before I am using Set RS = CurrentDb().OpenRecordset(qryTest) qryTest is a query that gets its record from a linked table. That is exactly what I want to employ, opening a recordset from a linked table.
Before I am using Set RS = CurrentDb().OpenRecordset(qryTest) qryTest is a query that gets its record from a linked table. That is exactly what I want to employ, opening a recordset from a linked table.