Form Design

[kronar30]

I want to build a form that lists all records in the job table, with a check box in front of each line to be checked if user wants to delete this record? how do I set this up?

 

[Axworthy]

I would add a yes/no field to the table with a name such as DeleteThisRecord, include this in the form, and then on close of the form, run

CurrentDb.Execute "delete from tblJob where DeleteThisRecord = True;"

 

[kronar30]

Great idea, thanks

 

[dhookom]

I would use a mulit-select list box to allow the users to select a record or records. Your code could then loop through the selected items in the list box building the correct WHERE clause for a delete query.

Duane
Hook'D on Access
MS Access MVP