#DELETED ???
I have a form that accepts data form users. I wan to delete any data that are
blanks. I put this on th "on load event of the form"
Dim stDocName As String
stDocName = "DeleteIt"
DoCmd.SetWarnings False
DoCmd.OpenQuery stDocName, acViewNormal
DoCmd.SetWarnings True
It run a query that deletes blank record in the table. Only problem I have
is that when the form comes up, all the fields display: "#DELETED"
If I check the table, no such entry exist and then when I run the form
again, it's gone. What happening?
|