Linked form can't be edited

[pkeegs]

I have a large table with contact details and also additional details which
only relates to about a third of my clients. If I include all the fields in
my main input form(1) it becomes very cluttered so I have created another
form(2) for just the additional information and select it with a button from
form(1). Form(2) is filtered according to the client in form(1). However even
though I have enabled editing in the properties box, I am unable to edit the
form(2) fields. Without the filter it works fine, but I have to find the
client manually to add the additional information. What have I missed?

Regards

 

[Banana]

I have a large table with contact details and also additional details which
only relates to about a third of my clients. If I include all the fields in
my main input form(1) it becomes very cluttered so I have created another
form(2) for just the additional information and select it with a button from
form(1). Form(2) is filtered according to the client in form(1). However even
though I have enabled editing in the properties box, I am unable to edit the
form(2) fields. Without the filter it works fine, but I have to find the
client manually to add the additional information. What have I missed?

Regards

I'm a bit fuzzy on how exactly the form is set up, but here's a link to
a good article that explains in general terms why a query would be
non-updatable:

http://allenbrowne.com/ser-61.html

Now, you talked about 'filtering' which may not be technically a query
but remember it's still a form of query executed by Access so if it has
a filter criteria that if copied to a WHERE clause in an identical
query, would reproduce a non-updatable query.

This will override any settings you may have, simply because Access has
no way of tracing the changes back to the original record so it prevents
changes.

HTH.

 

[pkeegs]

I've solved my own problem - go to properties in form(1), Data tab, select
Record Locks --> no locks. Simple eh!