Tables & Form Records - PLEASE HELP!!!

L

Liz

I had a form all set up and populated with 327 records in a table. While in the form, I hit "data entry" and all the records wiped out of the form. They are still in the table. How do I get them back into the form?
 
J

John Vinson

I had a form all set up and populated with 327 records in a table. While in the form, I hit "data entry" and all the records wiped out of the form. They are still in the table. How do I get them back into the form?
Click to expand...

Turn off Data Entry in the form properties.

The purpose of Data Entry mode in a Form is to do just that - to allow
you to enter new records but not to see old ones.

If you want to see old records, but default to jumping to the new
blank record when you open the form, add one line of code in the
Form's Load event:

Private Sub Form_Load(Cancel as Integer)
DoCmd.GoToRecord acNewRecord
End Sub
 
V

Van T. Dinh

Use the Menu Records / Remove Filter/Sort.

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
I had a form all set up and populated with 327 records in
Click to expand...
a table. While in the form, I hit "data entry" and all the
records wiped out of the form. They are still in the
table. How do I get them back into 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

Similar Threads

How do I clear a form? 0
Copy previous record into form field 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Help creating a search form in Access XP 0
Many (City) to Many (Zip Code) help 8
Duplicate Mail Merge Record Every Time 5
Request Form - Alert Team Member 0

Top