Created new database, "New" button not selectable. Please help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Everything else is working, pull down lists that I can actually select from,
and the tab order is correct. Except that at the end instead of going to the
next record, the tab sends you back to the top of the data just entered in my
form. Record buttons at the bottom the only things selectable are the last
and first record buttons. You can see the "New" record button, but it is
subdued and not selectable. I am using Access 2002.
 
Kathylaurel said:
Everything else is working, pull down lists that I can actually
select from, and the tab order is correct. Except that at the end
instead of going to the next record, the tab sends you back to the
top of the data just entered in my form. Record buttons at the
bottom the only things selectable are the last and first record
buttons. You can see the "New" record button, but it is subdued and
not selectable. I am using Access 2002.

That normally means that either the form has been configured to not allow
new records or that the form is bound to a RecordSource that doesn't allow
new records. If you bound the form to a source that uses more than one
table that is likely the problem. Many multi-table queries do not allow
editing of any kind.

Check the help topic "When can I update data in a query?"
 
Back
Top