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

unread,
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...?

Allen Browne

unread,
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.)

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

unread,
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
0 new messages