'new record' button not active in Access 2007 form (old 2003 form)

C

Chris Smith

I have upgraded a small local app from Access 2003 to 2007. I have a menu
that calls a few forms.

On the first form I tried to open from the menu, I've noticed that the 'new
record' button on the navigation strip is not enabled. And I'd really like to
add records using the form!

On the form properties I have Data Entry set to 'no', and 'allow additions',
'allow deletions', 'allow edits', 'allow filters' all set to yes.

Any suggestions?

Thank you
 
A

Allen Browne

Is the form's Recordset Type set to Dynaset?

If the form is based on a query, open the query directly, and see if you can
add a new record there. If you can't in the query either, then the problem
is not to do with the form.
 
C

Chris Smith

Problem now resolved. Thank you!



Allen Browne said:
Is the form's Recordset Type set to Dynaset?

If the form is based on a query, open the query directly, and see if you can
add a new record there. If you can't in the query either, then the problem
is not to do with the form.
Click to expand...
 
Top