We would like to be able to edit records on our forms. The forms are set to use a query.
I set the form to Dynaset (Inconsistent Updates) and allow edits.
Question: Is it better to create a recordset on form load, and use that recordset for the form? Then when there are data changes update the table? As you can tell I'm trying to learn and any input would be appreciated.
What am I missing?
I will attached a sample database for your reference.
Thanks in advance. Rick Cass