>
>Use a checkbox which is checked for a deleted record (since this is 'true' in your SQL-Select). You can show this in either a grid or data-entry form.
>
>Barbara
Then he would have to put code behind the check box (LostFocus?) to either delete or recall the record in the original table since this column is actually the return value of the Deleted() function. I usually put it in the LostFocus event just in case the user "sits on" the checkbox toggling it between checked and unchecked. Once the checkbox loses focus, I issue the appropriate recall or undelete based on the value of the checkbox and if the status of the record is the opposite of that value.
Mark McCasland
Midlothian, TX USA