Deleteing selected records with a button

[copewithit]

Hi all,

I'm trying to allow the user to search through records and using a checkbox, allow the user to select one or multiple records, then click a button and delete all that were selected. I'm thinking I should include some code that will delete all records that have the [deleterecord]=1. I know how to create buttons and use events, I'm just not sure on what the code should look like. I'm using Access 2003. Thanks for all your help!

[missinglinq]

Datasheet, Continuous Form or Single View Form? You should always include this info when posting questions involving forms; it can make a world of difference in our answers!

Linq ;0)>

[copewithit]

Datasheet, Continuous Form or Single View Form? You should always include this info when posting questions involving forms; it can make a world of difference in our answers!

Linq ;0)>

Sorry! It is a datasheet that is a subform in a single view form. I have the delete button on the single view form. Also, I already have the checkboxes in the datasheet subform, It is the task of deleted the ones that are selected that I am stuck on. Thanks again!

[missinglinq]

One way is to run a SQL statement to delete the records from the table the subform is based on, then Requery your subform.

Private Sub DeleteMultiRecords_Click()
Dim strQuery
strQuery = "DELETE * FROM YourTableName WHERE YourCheckBoxName" 'Define SQL statement
DoCmd.RunSQL (strQuery)  ' Run SQL
Me.YourSubformName.Requery  'Requiry to records go "poof!
End Sub

Good Luck!

Linq ;0)>

[copewithit]

Linq,

Thanks for your help. The code worked great and helped me get over a hurdle. Thanks again!

[missinglinq]

That's why we're here! Glad we could help!

Linq ;0)>