Avatar of CBHelpDesk
CBHelpDesk
 asked on

Cannot open form first try; get 'recordset is not updateable'. Will open it if close/reopen database and try again.

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?

Thanks
Microsoft Access

Avatar of undefined
Last Comment
Simon Ball

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Simon Ball

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
VBClassicGuy

Microsoft says:

"The table that you are updating is a linked table that does not have a primary key or a unique index. Or, the query or the form is based on a linked table that does not have a primary key or a unique index."
Simon Ball

but wouldn't that occur every time, not just on first load, if that were the problem?
CBHelpDesk

ASKER
I'll give the form Load function a try later today.

There is a primary key on the linked table so that eliminates one possibility.

Thanks for the quick responses!

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Simon Ball

also, are there multiple controls on the form drwing sperately from the data aset?  they might create locks on records?
CBHelpDesk

ASKER
The form contains information from the linked table (read only) and fields in a table in the current database (allow updates).

Database A - tblClient (linked table for reading) where the primary key is Client_ID
Database B - tblAddl_Info where the primary key is Addl_Info_ID

The form in Database B displays fields from both tables.

The query for the form in Database B is:
SELECT tblClient.*, tblAddl_Info.*
FROM tblClient LEFT JOIN tblAddl_Info ON tblClient.Client_ID = tblAddl_Info.Client_ID
WHERE tblClient.CBCS_Client=True;
Simon Ball

did the onload option not work then?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
CBHelpDesk

ASKER
Today went crazy so it'll be Monday before I can get to it.

Sorry for the delay.
CBHelpDesk

ASKER
I added the following to the form load and it worked like a charm.

   Me.RecordSource = "qry"
    Me.Requery

Thanks for all your help!
Simon Ball

excellent.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes