Forma and Disappearing records

J

Jeff C

This is strange and I cannot for the life of me figure it out.

A table full of records and a form using the table as the record set.

A user did something and now when opening the form, none of the records show
even though they are in the table.

Can anyone throw out an idea??? Thank you
 
K

KARL DEWEY

If the source for the form is a query then check it for results. Open the
form in design view and click on menu VIEW - Properties. Verify the Record
Source.
Was a filter added?
 
J

Jeff C

Form is using a table for the record source, opening the table shows all
records preseent. Open the form, verify the record source, no records visible
 
D

Dirk Goldgar

In
Jeff C said:
This is strange and I cannot for the life of me figure it out.

A table full of records and a form using the table as the record set.

A user did something and now when opening the form, none of the
records show even though they are in the table.

Can anyone throw out an idea??? Thank you
Click to expand...

Did the user maybe set the form's Data Entry property to Yes? Check the
Data tab of the form's property sheet in design view.
 
D

Dirk Goldgar

In
Jeff C said:
Data entry is set to yes, this should be no??
Click to expand...

That setting should be No, if you want to see any existing records on
the form. The Datra Entry property marks the form as being for data
entry *only*, meaning that no existing records are shown.
 
Top