I have a form which displays an ADO recordset from a table. The user can either select a record and edit it, or add a new record- pretty basic. However, in the add/edit form, I want to use a new recordset to add or edit the record because I'm using an MDI interface in which a user could view/add/edit multiple records at once. I want the new recordset to contain only the one record that is being added/edited. Editing is not a problem, but how can I create a recordset in which the only record is the one that I want to add?

I figured this would be better for performance than creating a new recordset that contains all of the records when all I want to do is add or edit one new record. Am I wrong?

TIA,
-Mike