Hi,
I hope this is the right forum.
I have an Access 200 database as a client to a SQL Server database. I have a form based on a linked table. However, sometimes when I update one of the fields (e.g. select from a combo box), the screen refreshes and displays the value before I made a selection. This happens intermittently but regularly, e.g I can change teh combo box ten times after that one problem and it will be fine but will re-occur later.
I've put a breakpoint in the code but this reveals nothing. There is nothing funny about the fields.
Does anyone know if this is perhaps a form event interfering with the user activity? Or a known problem with Access/SQL Server drivers?
Thanks.
I hope this is the right forum.
I have an Access 200 database as a client to a SQL Server database. I have a form based on a linked table. However, sometimes when I update one of the fields (e.g. select from a combo box), the screen refreshes and displays the value before I made a selection. This happens intermittently but regularly, e.g I can change teh combo box ten times after that one problem and it will be fine but will re-occur later.
I've put a breakpoint in the code but this reveals nothing. There is nothing funny about the fields.
Does anyone know if this is perhaps a form event interfering with the user activity? Or a known problem with Access/SQL Server drivers?
Thanks.