Form not showing all records.

[yeppy12]

I have a form that doesn't show all my records when I open it. For example, I open Access and then open the database. I click on my form to open it, and it shows no records. I know for a fact that there are several records entered into the database via my form, but the only way I can see them is to open the actual table to which my form is linked.

Is there something I need to do to correct this problem that will allow me to see every record entered using my form? Thanks.

 

[pbaldy]

One thought is that your form's Data Entry property is set to Yes.

 

[yeppy12]

Ok. I changed the DataEntry = No, but the problem now is when I exit the form and open it back up. The problem is still the same: the form only shows the new record and not the ones already entered. How can I fix this problem for good?

 

[pbaldy]

How are you opening it? It sounds like the method used is forcing it into data entry mode (unless you forgot to save it after changing the Data Entry property).

 

[yeppy12]

I am opening Access (i.e., the database) from a server rather than off the desktop. I did save after changing the Data Entry property.

The form autofills certain fields...could that be an issue?

 

[pbaldy]

I mean how are you opening the form itself?

 

[yeppy12]

I am opening the form from a switchboard.