Delete Record but not Really...

[PosseJohn]

I have a continuous form that shows record selectors.

If a user selects a record and tries to delete it, I check the authority
level of the current user and the author of the record itself.

If the current user was the author of the record and they have sufficient
authority, I make the field [chkRecordDelete] = True.

The form is based on a query that shows all records for [chkRecordDelete] =
False.

I am having trouble with updating the form so that the record they just
deleted (but in reality I've just changed a field value) doesn't show up any
longer.

I want to retain deleted records for record keeping purposes.

Thanx in advance...

 

[Gina Whipp]

PosseJohn,

Without seeing the code you are using to set your value to True I am going
to suggest a Me.Requery after the Delete action (OR a Me.Refresh) but
posting the code would probably help to get a more precise answer.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm