Forms will not allow me to add a new record? disabled

[Jack]

We are in a small business environment.
I set the form to go to a new record upon opening.
Strangely, now, select forms (perhaps due to a conflict)
disable the ability to go to a new record.
anyone have any idea why this might be?
We received an error: 'record has been deleted' when
trying to access the primary table. I compacted that table
and had success opening it and modifying the records
I compacted the forms but whenever I add a related table,
the dataset is not update-able..
even when I've manipulated the relationships.
hmmm?

 

[Van T. Dinh]

I think we need more info on:

* The relevant Table Structure, in particular, the PrimaryKey Field and the
ForeignKey Field.
* The set-up of the Form. Do you use Subform? Post also the RecordSource
of the Form (and Subform).
* What you meant by "adding the related Table"? In the RecordSource Query?

It is likely that you linked Table using a non-PrimaryKey LinkField and in
this case, the RecordSource of the Form is not updateable.

 

[Van T. Dinh]

In addition, I think you may have some corruptions in your database. Check
Tony Toews' Web site:

http://www.granite.ab.ca/access/corruptmdbs.htm