MS Access 2002 problem with subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access 2002 database.
On a form there is a subform containing a query that selects data from one
single table according to a few criterias on the parent form.
I have started this database a while ago and at that time I could select
and/or edit values in that subform that were reflected in the source table,
with no problem whatsoever.
Now, with no changes to this database - from my knolwledge at least - I
cannot edit any record from the subform. I can delete them.
If I go into RecordSource property of the subform I can edit the query, I
can also run it and edit the values within it, and the values change the
source table.
If I try to do this from the (sub)form, no change.
Any ideas...?
 
Check the properties of the form (i.e. the form that is the subform, looking
at the properties of the Form, not of some control.)

Particularly:
Allow Edits Yes
Recordset Type Dynaset
 
It seems the subform detail was locked.
I discovered this just before I read your post.
Strangely, I don't remember locking it, nor have I had any reason to do such
a dumb thing, either by hand or through code...
Thanks anyway
 
Back
Top