New Record not appearing in Table

[jayC]

When I created a new record in form view, the new record is not appearing in
the table.
What do I need to do to make it appear in the table?

 

[Armen Stein]

When I created a new record in form view, the new record is not appearing in
the table.
What do I need to do to make it appear in the table?

Well, that should do it.

- Make sure you moving off the record - it isn't actually written to
the table until then.

- I assume you're not getting any error messages. Try adding a record
directly into the table, specifying the same fields and values, and
see if it is added successfully.

- Make sure the form is actually bound to the same table (look at the
RecordSource property). It's a simple mistake, but it can happen if
you have some copies of tables.

- Are you looking directly at the table to see if the record is there?
Not a query? Because a query that has an inner join (lines without
arrowheads) to another table where there is no matching record will
exclude that record.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[jayC]

Well, that should do it.

- Make sure you moving off the record - it isn't actually written to
the table until then.

check. I even closed and restarted both the form and the table. The new
records remain in the form but do not appear in the table.

- I assume you're not getting any error messages. Try adding a record
directly into the table, specifying the same fields and values, and
see if it is added successfully.

I modified several records from the form and the table updated.

I tried copying the form record and pasting into the table and another
object called "paste errors" appeared. It might have something to do with
the order of fields because I added a couple of fields to the table since
creating the form, though they were added to the form also.
In 'paste errors,' the two new fields are the last two columns in the paste
error table. The two new field columns were inserted in a different place
in the table than they appear in the paste error table.

- Make sure the form is actually bound to the same table (look at the
RecordSource property). It's a simple mistake, but it can happen if
you have some copies of tables.
check.


- Are you looking directly at the table to see if the record is there?
Not a query? Because a query that has an inner join (lines without
arrowheads) to another table where there is no matching record will
exclude that record.

there is a query open but I am not looking at the query. The query did not
update with the new records either.

 

[Rick Brandt]

check. I even closed and restarted both the form and the table. The
new records remain in the form but do not appear in the table.

Then you are looking in the wrong table or you are looking in the wrong part of
the table. Are you expecting the new record to always appear at the bottom of
the table's datasheet or are you actually using "Find" or a filter to look for
it? Table datasheets have no reliable order when viewing them.

The form is getting that data from *somewhere* since it can't pull it out of
thin air.