URGENT...new and edit forms are locked!

[Guest]

After creating 250 new horse show Entries, the forms to create new Entries
and to edit existing Entries don't work. The new Entry form instead of being
blank comes up with an existing record and a message that says "You can't go
to the specified record.". The edit Entry form contains the correct Entry
record but the form does not permit any data fields to be changed. I can
operate normally in the tables.

The Entries table is a combination of rider table, horse table, and a bunch
of data. In the rider column I use a lookup for rider name rather than see
the record number, but in four Entries, instead of rider name, it shows
record number . In the rider table. these records are gone (deleted,
invisible, or something).

I can't get the forms unlocked. I have deleted the offending Entries, but
to no avail. I have compacted the file, pleaded, and cried, but again to no
avail. Can you help? Thanks in advance for any guidance.

 

[Joseph Meehan]

After creating 250 new horse show Entries, the forms to create new
Entries and to edit existing Entries don't work. The new Entry form
instead of being blank comes up with an existing record and a message
that says "You can't go to the specified record.". The edit Entry
form contains the correct Entry record but the form does not permit
any data fields to be changed. I can operate normally in the tables.

The Entries table is a combination of rider table, horse table, and a
bunch of data. In the rider column I use a lookup for rider name
rather than see the record number, but in four Entries, instead of
rider name, it shows record number . In the rider table. these
records are gone (deleted, invisible, or something).

I can't get the forms unlocked. I have deleted the offending
Entries, but to no avail. I have compacted the file, pleaded, and
cried, but again to no avail. Can you help? Thanks in advance for
any guidance.

My guess is the relationships, likely via a string of queries, are not
allowing updates because of some ambiguous relationships.

 

[Guest]

If what you say is true, what does that mean in terms of a redesign. What do
I have to do to fix the problem in the long term, and how do I get out of
this immediate problem, just go back to a backup, and hope that it doesn't
happen again?

 

[Bill Mosca, MS Access MVP]

Bob

Take a look at the form's record source query. Open it in design view and
then run it. If the new record icon in the navigation bar is not disabled,
the query is updatable. If it is disabled, you might have to rework the
query. Sometimes it's as simple as using the foreign key instead of the
primary key of the related table.

 

[Guest]

Bill,

That put me on the right track. I rebuilt the query table by table and
discoverd that the rider table was causing the problem. The primary key was
missing from the autonumber data field! when I replaced the key, everything
worked again.

How can a key be removed by an uninformed user who made changes only using
forms?? Is there some way for me to protect the key?