The record set is a representation of all records in a table, or the result of a query. You can create as many Recordset objects as you need. However, it can only refer to one record at a time as the current record.