"Add new record" button disabled on main form - please help!

  • Thread starter Thread starter Erin
  • Start date Start date
E

Erin

I have read the posts relating to this topic but could not find a
similar situation. I would appreciate any help!

I have five tables. Three are my main tables, and the other two are
the basis for my subforms. Nothing is based on queries.

I have a form that contains Controls whose source is from all three
main tables, plus it has two subforms whose sources are the subform
tables (both of the latter are one-to-many).

I had some spontaneous problems including unresponsive controls, error
messages, etc and after changing the property settings suggested by
another group member, I decided to create a new form. This new form
now refuses to let me add new records. (The subforms, however, will
both accept new records.)

I have checked to make sure all my primary keys are okay, and that
there are indexes for each table (is it okay to have more than one per
table?). Everything seems to be all right.

I don't want to simply change "Dynaset" to "Dynaset (Inconsistent
Updates)" because I don't want there to be unresolved data integrity
issues.

I would very much appreciate any help - I am a newbie, self-taught,
trying to get this project finished before my internship comes up!

Thanks,
Erin
 
Just a shot in the dark, but did you set the form to allow adding new
records?

I'm also a bit leery about your statement: "I have a form that contains
Controls whose source is from all three main tables" - the 'three'
doesn't quite make sense to me. Can you add data into the tbale
directly?
 
I have "Yes" under "Allow Additions" on the form's Properties. Is that
what you mean by setting it to allow adding new records?

What I meant by the other statement was that fields from each of the
three main tables are used on the one form. The form is based on the
three tables. It also contains two subforms. Does that make sense?
I'm sorry, I'm new at this and I thought it was finally complete. Then
the next day I opened it and suddenly disaster. I am incredibly
frustrated.

On another note, I tried to start from scratch this afternoon. I
imported all my data from Excel into new tables in a new DB, and
created the form again. This time I followed all the tips I've been
reading, like turning off AutoCorrect Name and all that. And this
time: it doesn't show that I have any records at all in there (there
are actually 271 records), nor will it let me add any new ones.

What have I done???

Thanks,
Erin
 
"What I meant by the other statement was that fields from each of the
three main tables are used on the one form. The form is based on the
three tables."
How are you doing this? Usually there's a query involved, but you said
it's all table based.
Alternatively, what is the record source of the main form - a query, or
as implied by what's written - 3 tables (which doesn't make sense).
 
The record source is a SELECT statement. It has fields from each of
the three tables in it.
 
Back
Top