Tables & Form Records - PLEASE HELP!!!

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

Guest

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?
 
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
 
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?
 
Back
Top