data is missing from my form in Acess

J

Jessica

Hello all,
I input data in my form and when I close the form the data is missing.
Funny thing is the data shows up in the corresponding table and on some
reports (but not all). So it is in they system but for some reason it is not
showing up in the form. (This has never happened before and I have been
using this database for over a year now. It is maybe getting too big?
Please help...Thanks in advance
 
J

John W. Vinson

Hello all,
I input data in my form and when I close the form the data is missing.
Funny thing is the data shows up in the corresponding table and on some
reports (but not all). So it is in they system but for some reason it is not
showing up in the form. (This has never happened before and I have been
using this database for over a year now. It is maybe getting too big?
Click to expand...

If the database is over two billion bytes it's getting too big. Do you Compact
and Repair occasionally?

It sounds like your Form may have (intentionally or not) been set to Data
Entry mode. View the form's Properties and check that property; if Data Entry
is set to Yes you can enter new records but not view old ones.

Or, you might have set a Filter on the form and saved it with the filter. See
if the "funnel" icon looks like it's been clicked, or if the status bar at the
lower left says (Filtered). If so remove the filter.

John W. Vinson [MVP]
 
J

Jessica

Thanks so much for your response, I truly appreciate your support in this
matter. Unfortunately, records in the form still do not show up. I tried to
compact and repair it and even more of my records are gone. In the form, the
data entry is set to "no". But the filter icon does look depressed. But I
cannot seem to get it off.

Thanks
Jessica
 
J

John W. Vinson

Thanks so much for your response, I truly appreciate your support in this
matter. Unfortunately, records in the form still do not show up. I tried to
compact and repair it and even more of my records are gone. In the form, the
data entry is set to "no". But the filter icon does look depressed. But I
cannot seem to get it off.
Click to expand...

Open the form and select Records... Remove Filter/Sort from the Menu then.

John W. Vinson [MVP]
 
Top