Access- Records added in Tables Tab aren't accessible in Forms?

[Guest]

I added a few new records into an existing table. I closed and saved the
table and went back into forms. I opened a new form and when I tried to
select the new record that was entered...it wasn't there! However, it is
saved in the table. Any suggestions?

 

[Rick B]

First, don't enter records in a table. Your table should not be used as an
interface once you build it. Enter records in a query or a form.

But, you should see the records in the form if they are in the table. What
is the data source of your form? Is it based on the table or a query? Most
likely a query. Is this query limiting the records displayed? Does it have
some criteria that would exclude the records you just added?

 

[Guest]

Check the form record source, mybe there is a filter there (where condition)
Also, check the filter properties of the form if there is a filter specified
there

It will let you add records, but as soon as you open the form it wont be
displayed

 

[Guest]

The data source for the form is the table. How do I find out if there is
criteria excluding the new information added to the table?

This was created by someone else...I am just using it now.

Thanks!

 

[Rick B]

If the form is based on the table, not a query, then there should be nothing
limiting the display. Whatever is in the table should show up in the form.
Are you seeing any records in the form? If you are not seeing any records
at all in the form, then you might check the form's "data entry" property.
This would need to be changed to No.

Other than that, you could check the "filter" property.