Cannot open form first try; get 'recordset is not updateable'. Will open it if close/reopen database and try again.
Posted on 2011-03-04
My database has a switchboard that allows you to open a form. This form links to a table in another database in a different directory. The information displayed on the form is controlled by a query so it only picks records where a checkbox is set.
When I open the database and click the button on the switchboard, it says 'recordset is not updateable'.
If I close the database, reopen it and click the button, the form displays.
Any suggestions on what I should be looking at?