Using the FindFirst method in a DAO recordset.
Q: Peter Lucero is having problems using the FindFirst method in a DAO recordset based on a table, using the following syntax:
Set Rst = dbs.OpenRecordset(tablename)
A: This is because when you create a DAO recordset based on a table, without specifying the recordset type, it will be created as a table-type recordset, which doesn’t support the Find* methods. If you specify a dynaset-type recordset, the Find* methods will work:
Set rst = dbs.OpenRecordset(tablename, dbOpenDynaset)