WHAT HAVE I DONE?!?!?

[Courtney]

I have somehow managed to delete records so that I can now no longer create a
new record in my form or in my table.

Please can someone tell me how I can un-do what I've done so I can continue
to use these forms I've taken so much time creating?? I can provide more
information about this problem I'm having if I haven't provided enough.

Thanks in advance!!

 

[Stockwell43]

Hi Courtney,

I am not sure what happened unless the database is corrupted. However, you
can do anything about the records you already deleted but try to import
everything into a newly created database. Just create a new file and import
everything from your current one to the new one and it should be ok. If not,
I don't know how you would fix it.

Hope this helps!

 

[Jerry Whittle]

What error message are you getting? Are you having the same problem when
entering data through a form or directly into a table?

 

[John W. Vinson]

I have somehow managed to delete records so that I can now no longer create a
new record in my form or in my table.

Please can someone tell me how I can un-do what I've done so I can continue
to use these forms I've taken so much time creating?? I can provide more
information about this problem I'm having if I haven't provided enough.

Thanks in advance!!

Since you don't say what you did to cause this change, nor anything about the
structure of your form or your table, it's a bit hard to answer!

If you look at the table, not using the form, is the data there?
Open the Form in design view, and take a look at its Recordsource property.
What's there? If it's a Query click on the ... icon by it, and see if you can
open the Query as a datasheet. Does it have a blank new record line indicating
that it can be updated? If not, open the query in SQL view and post the SQL
here.

 

[Courtney]

I appreciate all of the responses you all have given me. Miraculously, the
problem has resolved itself. I'm not sure what happened or why it is now not
happening, but I thank you for your assistance.