Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
MS Access 2002 problem with subform
0 views
Skip to first unread message
mirceaar
Nov 21, 2007, 5:52:01 AM11/21/07
to
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...?
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...?
Allen Browne
Nov 21, 2007, 7:21:29 AM11/21/07
to
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.)
at the properties of the Form, not of some control.)
Particularly:
Allow Edits Yes
Recordset Type Dynaset
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"mirceaar" <mirc...@discussions.microsoft.com> wrote in message
news:C89EF827-6E59-4DA4...@microsoft.com...
mirceaar
Nov 21, 2007, 9:02:00 AM11/21/07
to
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
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
0 new messages