Getting rid of #DELETE on form with application.echo

[Swann]

Hello,
I have a form linked to a table with a button that deletes the
currently selected record with a VBA sub. When I perform the delete
query, the data in the fields are replaced with #DELETE, something I
would rather not occur. I would really prefer that the fields just
appear blank. Sifting through some of the messages on this newsgroup
has revealed that setting something called application.echo equal to
false will prevent this from occuring. However, none of my
experimentation with application.echo has worked.

Basically, this is what I have tried to do (bear in my I have really
have no idea what I'm doing):

private sub delete ()
dim db as dao.database
set db = dbcurrent

dim strSQL as string
string = "Delete query stuff."

application.echo "false"
db.execute(strSQL)
application.echo "true"

end sub
Thanks for your help!
Swann

[Bradley]

Swann wrote:

Hello,
I have a form linked to a table with a button that deletes the
currently selected record with a VBA sub. When I perform the delete
query, the data in the fields are replaced with #DELETE, something I
would rather not occur. I would really prefer that the fields just
appear blank. Sifting through some of the messages on this newsgroup
has revealed that setting something called application.echo equal to
false will prevent this from occuring. However, none of my
experimentation with application.echo has worked.
Try requerying the recordset.
Basically, this is what I have tried to do (bear in my I have really
have no idea what I'm doing):

private sub delete ()
dim db as dao.database
set db = dbcurrent

dim strSQL as string
string = "Delete query stuff."

application.echo "false"
db.execute(strSQL)
application.echo "true"

end sub
Thanks for your help!
Swann

--
regards,

Bradley

[Salad]

Swann wrote:

Hello,
I have a form linked to a table with a button that deletes the
currently selected record with a VBA sub. When I perform the delete
query, the data in the fields are replaced with #DELETE, something I
would rather not occur. I would really prefer that the fields just
appear blank. Sifting through some of the messages on this newsgroup
has revealed that setting something called application.echo equal to
false will prevent this from occuring. However, none of my
experimentation with application.echo has worked.

Basically, this is what I have tried to do (bear in my I have really
have no idea what I'm doing):

private sub delete ()
dim db as dao.database
set db = dbcurrent

dim strSQL as string
string = "Delete query stuff."

application.echo "false"
db.execute(strSQL)
application.echo "true"

end sub
Thanks for your help!
Swann

Have you considered using the OnDelete event instead?