Delete Record

[rgreene]

I have a library database that I want to delete a record in my tblStatus when the book is returned. I have found the deleteobject function but it appears that that will delete like a table or query or report or something like that. I have no need to keep track of how many times a certain book has been checked out or that John Doe has checked out books X, Y and Z. As a mater of fact that is exactly what I don't want so I just want to delete the record that says Book ZZZ was checked out by John Doe. When the book is returned I just want it available for some one else.

Thanks in advance,

Rick

 

[gemma-the-husky]

if you have the current record selected on a form then

application.runcommand accCmdDeleteRecord

will do the job


otherwise a sql statement such as

"delete * from a_particular_table where [tableref] = " & recordref

should do it