I'm using Access 2002 as a front end to a SQL Server 2000 database. I Update a status field in a SQL Server table using a parameter based stored proc. Works great. Then in the same sub, I open a popup form to view the record I have just updated.
If I open the Popup Form automatically in code, the status field is not updated. If I open it from a button on the form, it works great.
I have tried every trick I know to force the SQL Server table to be updated before I open the Popup Form, but nothing works. I have tried (1) Doevents, (2) Requerying the Popup Form, (3) Requerying the updated recordset (4) Opening the updated recordset in code.
Any other Suggestions?
If I open the Popup Form automatically in code, the status field is not updated. If I open it from a button on the form, it works great.
I have tried every trick I know to force the SQL Server table to be updated before I open the Popup Form, but nothing works. I have tried (1) Doevents, (2) Requerying the Popup Form, (3) Requerying the updated recordset (4) Opening the updated recordset in code.
Any other Suggestions?