Lost records in form - please help!!

  • Thread starter Thread starter Neil Hindry
  • Start date Start date
N

Neil Hindry

I have a problem that I hope you will be able to help me solve.

I have a simple database to hold addresses, telephone, number, email
addresses etc in Access 2002, it came as part of Office XP. I created a form
a few weeks ago and everything was fine. However I now seem to have a
problem.

I opened my form as normal to enter a new record, but it shows a blank
record and at the bottom where it say the number of records in the database
it says 0. However, when I view the records using the table there are 99
records. Have you any idea what is happening? I have not changed anything
recently and the last time I used it everything was ok.

Can you help me solve my problem?

Any advice or information given will be gratefully appreciated.

Thanks!!
 
In the form design view, check the Record Source property
of the form. This property binds the form to you table or
query and in turn allows you to use the fields in the
table or query as those that can appear in your form. You
may have changed the Record Source.
 
You may possibly have the records filtering to display no
records. Open the form and right-click on the bar at the
top and choose "Remove Filter/Sort". If your records
display then that was your problem. Then check to see if
there's an active filter loading with the form.
 
Back
Top