Recordset is not updatable

[GSB]

Hi, Im new with Access, need some help please.
I have a form (Main Form) where user enter parameters to run a query (qryA).
Results are showed in a subform (subfrmA), which is a table with basic
information. User can´t edit anything from here.

When user double clicks one of the records, another form appears with the
detailed information (frmDetails) and user is allowed to edit records from
there.

The problem is that when I try to edit those records, “Recordset is not
updatable†message appears at the status bar and I can’t edit anything.

I’m guessing this is because both subfrmA and frmDetails are based on the
same query (qryA), but I don’t know how to fix it.

If I open frmDetails alone, I can edit records.

 

[Dirk Goldgar]

Hi, Im new with Access, need some help please.
I have a form (Main Form) where user enter parameters to run a query
(qryA).
Results are showed in a subform (subfrmA), which is a table with basic
information. User can´t edit anything from here.

When user double clicks one of the records, another form appears with the
detailed information (frmDetails) and user is allowed to edit records from
there.

The problem is that when I try to edit those records, “Recordset is not
updatable†message appears at the status bar and I can’t edit anything.

I’m guessing this is because both subfrmA and frmDetails are based on the
same query (qryA), but I don’t know how to fix it.

If I open frmDetails alone, I can edit records.

That last statement suggests that the problem isn't with the query. What
line of code or macro action opens frmDetails?

 

[GSB]

In my subform table I have the following macro to open frmDetails when user
double clicks a record. I´m using Macro Generator:
Action: OpenForm
Form Name: frmDetails
View: Form
Where Condition: ="[WName]=" & """" & [WName] & """"

 

[Dirk Goldgar]

In my subform table I have the following macro to open frmDetails when
user
double clicks a record. I´m using Macro Generator:
Action: OpenForm
Form Name: frmDetails
View: Form
Where Condition: ="[WName]=" & """" & [WName] & """"

And there are no other arguments passed by that macro? It doesn't specify
the Data Mode as read-only? I don't see anything there that would account
for the form's recordset not being updatable when opened by the macro, yet
updatable when opened directly via the user interface.

Is there anything else about the calling form that might explain it? Do you
lock the table when you open that form -- specifying the form's (or
subform's) Record Locks property as "All Records", for example?

If you have the main form open, and then open frmDetails by double-clicking
it in the Navigation Pane or Database Window, rather than by double-clicking
on a subform record, is it updatable?