Record Delete

[Puru pela]

I intend to use a command button on the main form to delete a selected record on a subform. Any tips will be gladly appreciated

[Seth Schrock]

I would do it with a Delete query, which means you will need some means of uniquely identifying the selected record in the subform (usually the primary key field, but can be a combination of fields). Then in the OnClick event of your button, you just us the DoCmd.RunSQL() command and provide the SQL code for your delete query that has a WHERE clause to matching your unique record. Then all you have to do is requery your subform for the deletion to be seen.