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

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top