Introduction Multiple Recordsets - the ability to stuff multiple SQL query results into one Recordset - is an ADO feature that's few developers are aware of.In this article, we are going to take a look on what a Mutliple Recordset is, exactly, and how it can make your development life easier (and your code more efficient).Here are examples: In this case, when performing data entry, the user must always provide a value for the Last Name column in order to create a record.If you omit to specify the nullity of a field, it is assumed to be NULL.However, you can immediately display the most current data by refreshing the records.You can also perform a more thorough update by requerying the data.
You can requery data manually, by using a macro, or by using code.
Refreshing records only updates the data that already exists in your datasheet or form.
It does not reorder records, display new records, or remove deleted records and records that no longer meet specified criteria.
Allowing Record Addition on a Form To make data entry possible, the form is equipped with a Boolean property named Allow Additions. If you want to prevent the user from adding a new record to a form, set its Allow Additions property to False.
Here is an example: The user would be able to change existing records, even possibly to delete an existing record but not create a new record.