deleting records from filtered view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My database has a table that has all phone calls taken by various members of
a department. I then have it set up to filter by user. One form shows All
Calls, another form shows Pam's calls, Kerry's calls, etc. Each individual
user (use Pam as an example) view record source is a query that contains the
tblCalls table. It has 2 rows of criteria set up to show either all calls
taken by Pam or all calls assigned to Pam by other users.

My problems is this: I can DELETE calls when I am in the ALL CALLS view (no
criteria). But as soon as I get into a specific user view, it acts like it
is going to delete the call, but as soon as you close the form & reopen it,
the record is back. It never gets deleted from the table. I am assuming
this is because it's a filtered view.

I need to have a way for individual users to be able to delete their own
calls. Is there a way I can do this?
 
The filtered view should have no bearing on the delete abilities.

You may want to describe more about the "it acts like it..." part, like the
messages that are displayed, how the delete action is executed, etc.
 
It acts like it is going to delete - It gives a message "You are about to
delete 1 record". But when I close the form & reopen it, the record is still
there. And it's still in the table. The form for ALL calls works fine for
deleting records. The other views are just copies of that form with an
identical query running it, other than the query now has a user name in the
criteria field.
 
Back
Top