Delete Record but not Really...

  • Thread starter Thread starter PosseJohn
  • Start date Start date
P

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...
 
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
 
Back
Top