I have a continious form, based on a table (fd_inspector) - showing 2 fields "food inspector" and "delete" which is a yes/no field.
There is a command button "close" which when pressed I'd like the record in the table "food inspector" to be deleted, ONLY WHERE the "delete" field has been ticked (i.e. = yes)
I want to do this NOT using a query, so the user would have to click OK to confirm "data will be modified in the table (fd_inspector), I just want the user to tick, close and thats it! that food_inspector is deleted
Regards
Gwilym
There is a command button "close" which when pressed I'd like the record in the table "food inspector" to be deleted, ONLY WHERE the "delete" field has been ticked (i.e. = yes)
I want to do this NOT using a query, so the user would have to click OK to confirm "data will be modified in the table (fd_inspector), I just want the user to tick, close and thats it! that food_inspector is deleted
Regards
Gwilym