Good afternoon and Happy Thanksgiving! I have a question on which would be the more efficient method of working with a form in a particular situation.
Access is acting as the front-end to a SQL Server 2000 database. There is an ADO connection object created at startup, and used by all relevant processes for connecting to SQL. I have created a custom object within Access to retrieve a record by its ID via stored procedure (using the aforementioned ADO connection), and to return a disconnected ADO recordset containing that record. After the form is populated with that recordset, an object method (Update) will call a stored procedure that updates the record in SQL. My question ... which of these is more efficient? - Completely unbound form, with code to populate each control from the recordset - Form bound to the disconnected recordset In either case, once a form field has been changed, code will execute to change the Enabled property of the cmdSaveRecord and cmdUndoRecord command buttons. (I know how to do this part, no help being requested here) Which of the two options is better? Or is it just a matter of programming preference? Thanks in advance! Bryant
