Linked form can't be edited

  • Thread starter Thread starter pkeegs
  • Start date Start date
P

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
 
pkeegs said:
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
Click to expand...

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.
 
I've solved my own problem - go to properties in form(1), Data tab, select
Record Locks --> no locks. Simple eh!
 
Back
Top