Delete select Records from an access table via a form

[Guest]

I want to delete the active record from a form...fields include: FirstName,
LastName, EmployeeID, DeptCode. The dept code field is supplied from another
table using a combo box.

Created a command button for the delete action but cannot figure the code
required to simple delete the record. Any help would be appreciated.

 

[G. Vaught]

If you add a command button on your form in design view it should activate a
wizard that allows you to place a delete button on the form. Upon execution
it will delete the current record.

I would not place a command button to delete multiple records on a form.
This could be very dangerous.

To delete a group of records from a table create a query to run based on the
required criteria to delete.

 

[David C. Holley]

Create a command button and use the wizard to create the code.

 

[Guest]

Thank you David and G. Vaught...very helpful and worked like a charm.