can not see all the info in the table

  • Thread starter Thread starter hawk
  • Start date Start date
H

hawk

Hi, All,
I have a form that collect some info and insert these info
into MS access(2000) database by clicking a 'OK' button.
Everything is fine except I can not see the new inserted
row in the table when I use Docmd.OpenTable "Table_one",
acViewNormal to open the table after insert data. This
line is at end of the code for 'OK' button. What's wrong?
Why the data already in the table but can not be shown?

Did I forget something?
Thanks and have a good one

Hawk
 
well, there are potentially dozens of reasons why you
can't see your data

can you see any data at all?
if you can, theres a good chance there is a filter
somewhere, or you're opening the wrong table

was the update actually successful?
if you go look at the table, is the record actually being
added?

if it isn't theres a good chance an error is occuring that
you are missing

if you used On Error Resume Next, change it to On Error
Goto Error, and make sure to handle the error

also make sure that if you are using CurrentDb.Execute,
that you specify dbFailOnError
 
Thank you, Dave

I open the right table, also the data already in the table.
only the new row could not be shown, I can see the rest of
data. If I open the table manually, the new row is there.
if I use Docmd.OpenTable, only show me the old info (not
include the new row). BTW, there is not error when i trace
the codes.

thanks,
 
Back
Top