Form won't allow adding new records??

[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?

 

[Jim/Chris]

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

 

[heg]

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.

 

[John Vinson]

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.

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!