Starting a new record

[Guest]

I must have done something. When going into any of my forms or even creating
a new form, I have lost the ability to open a new record. The arrows at the
bottom of the form are grayed out. I can go to the next record or previous
record, however, I cannot open a new record.

 

[Larry Linson]

I must have done something. When going into any of my forms or even
creating
a new form, I have lost the ability to open a new record. The arrows at
the
bottom of the form are grayed out. I can go to the next record or
previous
record, however, I cannot open a new record.

Likely culprit, the Allow Additions property (under the Data tab in the
Form's property sheet) somehow was set to "No". If you can only view the
Records that you see, it could also be that you made some change that caused
the Query that is the Form's RecordSource to be un-updateable.

Larry Linson
Microsoft Access MVP

 

[Guest]

It's not the "Allow Additions". I can't add anythiing to any form. Maybe it
is in the query. Would I be able to fix that?

 

[John Vinson]

It's not the "Allow Additions". I can't add anythiing to any form. Maybe it
is in the query. Would I be able to fix that?

Depends on the query. See "Updateable" in the online help for some
reasons why a query might not allow updates. Or, open the Form's
Recordsource as a query - does it have a *> "new record" line at the
bottom? If not, open it in SQL view and post the SQL text here, maybe
someone can spot the problem.

John W. Vinson[MVP]

 

[Guest]

Thanks! I used your idea and went into the SQL view. Copied the information
from a query I redid and it is now fixed! This saved me from redoing a form
under the new query, reports, etc.