Error: Record is Deleted

L

Lester

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
 
R

Rick B

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


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
 
L

Lester

Hi Rick,

Thanks for your info. You just didn't have to go and reply to everyone of
the posts. This way you killed all the active questions. I did it
unconcessiously but did it concessiously and that's a big difference.
Thank you Ricki
 
Top