Error: Record is Deleted

Hello,

I display records on the form. Then I delete one of the records directly
from the table. Then I want the form to redisplay the records except the one
that is deleted. However, I click on the form after the delete event I get
the error saying that the "Record is Deleted" and the fields of that record
are filled with "#Deleted". I tried to refresh, repaint and requery and
nothing worked.
I also, run a process on the same form where I append a record to the table
and the requery works fine. The new records appear on the form right away.
However, when I delete the records they are filled with the "#Deleted".

How to refresh the form to reflect the deletion of the record after delete
statement was run:
db.execute( "delete * from table1 where field1 = "blah")
me.requery --doesn't work
me.refresh --doesn't work

Any help is greatly appreciated,
Lester

Lester:

Please do not post your questions in multiple groups. I'm sure you feel
your question is very important, but you do not need several people working
on it.

Rick B

"Lester" wrote in message
...
Hello,

I display records on the form. Then I delete one of the records directly
from the table. Then I want the form to redisplay the records except the one
that is deleted. However, I click on the form after the delete event I get
the error saying that the "Record is Deleted" and the fields of that record
are filled with "#Deleted". I tried to refresh, repaint and requery and
nothing worked.
I also, run a process on the same form where I append a record to the table
and the requery works fine. The new records appear on the form right away.
However, when I delete the records they are filled with the "#Deleted".

How to refresh the form to reflect the deletion of the record after delete
statement was run:
db.execute( "delete * from table1 where field1 = "blah")
me.requery --doesn't work
me.refresh --doesn't work

Any help is greatly appreciated,
Lester