Hi to All,
A subForm (Default View: Continuous View) on a main Form has records. The subForm has Allow Edits = No and Allow Deletions=No. This is done to prevent editing after the record is saved and to prevent deletion by mistake. Beside each record on the sub Form there are two buttons: Print button to print the selected record (Is functional) and a delete button.
If the delete button is clicked for a saved record then a message box shows asking to confirm the operation or not. If deletion is confirmed then a check box is turned on for a field named MarkedDeleted (Yes/No) and the subform is re query.
If the delete button is clicked while editing a new record then cancel the editing of this new record.
The third case is if record selector is on new record, message box saying you need to select a record before deletion.
How can this be done?
Khalil