I have a form with the source being and ADO recordset. I am doing this because I display 2 records at a time on the form, a before and after state of the record. There is a check box which the users can check and it updates the appropriate field in the ADO recordset.
I use rst.Update do accomplish this. However, users would get run time error 91 when doing this. I checked microsoft.com and this is a known issue. I decided to use an ADO command and an update SQL statement to get around it. Herein lies my problem. After executing the ADO Command and moving to a new record and then back, the check box does not reflect the change. Apparently, the recordset that is the source of the form is not dynamic. How can I remedy this.
Phil Edwards
I use rst.Update do accomplish this. However, users would get run time error 91 when doing this. I checked microsoft.com and this is a known issue. I decided to use an ADO command and an update SQL statement to get around it. Herein lies my problem. After executing the ADO Command and moving to a new record and then back, the check box does not reflect the change. Apparently, the recordset that is the source of the form is not dynamic. How can I remedy this.
Phil Edwards