Is there a more elegant way of deleting records from VB than this? >>> (1 Viewer)

[daninthemix]

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

 

[Bat17]

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord

Peter

 

[daninthemix]

Any way of physically removing the data from the table by code wihtout referring to menu commands?

 

[Bat17]

create a delete query using the form as criteria, then requery the form?

Peter

 

[steevie_t]

Or just execute a little bit of SQL.


CurrentProject.Connection.Execute "DELETE * FROM tblMyTable WHERE lngMyTableID = " & lngRecIDToDelete & ";"

Me.Requery

 

[Pat Hartman]

You can also set a reference to the form's RecordSetClone and use DAO to delete the record.