LeanneGodney
Technical User
Hi there,
I am using Access 2002 ADP and SQL Server 2000.
I am using a disconnected recordset which is being used as the recordset of a form. Through code if I write to the RS then on occasion it doesn't display this change unless I use the RS.update feature.
Under normal circumstances this wouldn't be a problem but I find when I do this it makes the RS unstable and causes access to crash if I deal directly with the RS when saving.
Does anyone know how to display changes to the RS on the form? Even setting the forms rs property doesn't necessarily work cos the RS itself needs to update with the change made through code...
Not sure if this makes sense... Let me know if not.
Thank you in advance!
Leanne
I am using Access 2002 ADP and SQL Server 2000.
I am using a disconnected recordset which is being used as the recordset of a form. Through code if I write to the RS then on occasion it doesn't display this change unless I use the RS.update feature.
Under normal circumstances this wouldn't be a problem but I find when I do this it makes the RS unstable and causes access to crash if I deal directly with the RS when saving.
Does anyone know how to display changes to the RS on the form? Even setting the forms rs property doesn't necessarily work cos the RS itself needs to update with the change made through code...
Not sure if this makes sense... Let me know if not.
Thank you in advance!
Leanne