Use a form to delete a record

[ARW17]

I’m trying to give users the option to delete a personal day that they have scheduled. I figured out how to have them add a day, but deleting one seems more difficult…

What I want is to say in the AttendanceEvents table, delete the record where the EventDate field = date in the text box on the form, the USRI field = the USRI text box on the form, and the EventCode = “P”.

 

[Joe4]

Here is a high-level view of one way of doing this.

First, create a sample query that does this for one person.
Then, change your query to SQL View, and copy and paste this code somewhere for future reference.
This is the SQL code you want to create via VBA.
So, I would then have your form create the SQL code you need via VBA, and then run that SQL code from VBA to delete your data.

 

[Micron]

The sql statement is much like you described it. Try this on a backup copy of your table and note that if more than one line in that table could satisfy the criteria, you would lose more than one record. You could create this in vba on the form or call a query based on the statement as long as the form is open when you do so. Of course, you have to provide your own names for the form and its controls, and I'm assuming EventCode is a field in the same table.

DELETE * FROM AttendanceEvents WHERE AttendanceEvents.EventDate = Forms!frmMyForm.txtEventDate AND AttendanceEvents.USRI = Forms!frmMyForm.txtUSRI AND AttendanceEvents.EventCode = "P";