Form won't allow adding new records??

  • Thread starter Thread starter heg
  • Start date Start date
H

heg

I designed a new data input form. The underlying tables
have data from the first test of the form only. When I try
to add a new record I get the message "You can't go to the
specified record. You may be at the end of a recordset".
The New Record navigation control is greyed out.

What could be causing this?

The form's recordset property = Dynaset
I checked all relationships to be sure that the "many"
side of each is included in the underlying query.

What else can I check?
 
It sounds likm the query the form is based on is not an
updateable query. Run the query and see if you can add
records there.

or

In the form properties is the "Allow Additions" set to Yes?

Jim
 
Thanks for the suggestions. Allow Additions is set to Yes.
I cannot add records to the query, nor can I see what is
blocking me. The Add Record icon is greyed out on the
query, just as it is on the form the query supports. If I
scratch my head any more, I'll bleed.
 
Thanks for the suggestions. Allow Additions is set to Yes.
I cannot add records to the query, nor can I see what is
blocking me. The Add Record icon is greyed out on the
query, just as it is on the form the query supports. If I
scratch my head any more, I'll bleed.
Click to expand...

Not all queries *are* updateable. Common issues:

- In a multitable query, you must have a unique Index (such as a
Primary Key) on the "one" side table's linking field, and a nonunique
index on the "many", for each join.
- No Totals query, or any query containing any totals operation such
as Count, Sum, Group By or the like, will allow updating.

If neither of these apply, please open the Form's Recordsource query
in SQL view and post the SQL text here. Maybe someone can see what's
wrong!
 
Back
Top