Can't Update Form

  • Thread starter Thread starter BW
  • Start date Start date
B

BW

I have a form that users use to enter data into. We have been using this
form for 2 years entering in new sites. the form uses 2 tables that are
linked. Yesterday the form started coming up with the new record navigator
button disabled and I can't even edit existing recordsets. Any ideas?

Brent
 
Check that the the following properties of the form (under the Data tab) are
set to YES:
Allow Edits
Allow Additions

-Dorian
 
I checked each of those and they were fine. If I remove either of the
tables from my record source then it comes up allowing me to add
records.(minus the fields that are in the other table). Could my backend
database have some corruption in it? It has worked fine for 2 years with
the tables joined.

Brent
 
Hi BW,

Honestly don't know why it would work and then not work; could be
corruption. The bigger question is why is it necessary to have a multi-join
recordsource? Are you trying to update two tables at once, or is it just so
you can display the related data in the second table?

Brian
 
(1) Check that your code compiles
(2) Do a 'compact and repair'

You could also try running your query independently and try updating a
column in the result set. Perhaps your recordset is not updatable. If you
look in Access HELP it tells you in some detail what recordsets are updatable.

-Dorian
 
I was able to get this to work by changing the forms Recordset Type to
Dynaset (Inconsistent Updates). I just puzzled as to why this had worked
for 2 years with it set to Dynaset. I'm going to look through the tables
and look for strange data in the linking fields.

Thanks
Brent
 
Back
Top