Move to new record is greyed out

[Guest]

I am trying to figure out why I can't enter data in a form. I can see that
the move to a new record button at the bottom of the form is greyed out
(unavailable). I have checked the form property "Data Entry" and it is set
to "Yes" (along with Allow Edits, Allow Deletions and Allow Additions).

Any idea why I can't move to a new record in this form or edit any of the
fields in the form?

Thank you,
Judy Ward

 

[Guest]

Usually this is because you either have not set a control source on your form
or (and this is the most common) your control source is not an updateable
query or table.

Does your form have a control or record source?

If no, add one.

If yes, is it a query?

if no, then your table may not have a primary key.

If yes, does the query have more than one table?

Most queries that have more than one underlying table are not updateable.

Post back your answers and I (or other more knowledgeable people) will help
you with the next step.

Randy

 

[Guest]

I have experienced what you are describing--not being able to edit a record
that is created by joining more than two tables. The source of my form is a
query that does have two outer joins. All of my tables have Primary keys.
What is so strange is that I have the same exact query and same form in a
copy of this database that DOES allow me to make edits. I feel like I am in
the twilight zone!

 

[Powderfinger]

Is your Form's "Recordset Type" set to Dynaset?