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