Forma and Disappearing records

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

Guest

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

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.
 
In
Jeff C said:
Data entry is set to yes, this should be no??

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.
 
It should be No unless the form is ONLY to be used to create new records.
 

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

Back
Top