why am i getting #Deleted results when using an ACCESS form?
scubadiver - 24 May 2007 12:40 GMT
Its usually because you have deleted something in the table or tables,
lookup combo boxes and other reference information that can no longer be
shown.

Signature
http://www.patriotsquestion911.com
http://www.911truth.org
http://www.wtc7.net
http://www.st911.org
http://www.journalof911studies.com
http://www.pilotsfor911truth.org
http://ae911truth.org
> why am i getting #Deleted results when using an ACCESS form?
Ofer Cohen - 24 May 2007 13:28 GMT
Are you deleting the record using a query?
In that case you need to run
Me.Requery
after running the query, to refresh the data in the form
********
Another option will be to run the code
RunCommand acCmdDeleteRecord
to delete the record that has the focus in the form

Signature
Good Luck
BS"D
> why am i getting #Deleted results when using an ACCESS form?