Not a dumb question. It's a good one. If you remove delete data permission
on a table for a user, that user won't be able to delete data from that table
no matter which way he tries, not in the table, not in a query, not in a form,
not by code or a macro.
So how do you only allow the user to delete records using a form? Another
good question. Remove all permissions to the tables from all users except
from the Admins group and any special group you want to have certain data
permissions. As a member of the Admins group (which has permissions to the
tables) write a select query that shows the data in the table and give it
"run with owner's permissions" (RWOP) and base the form on that query. Then
give the users permission to open/run the form. When the user opens the form
and pushes the button to delete the record, it works (because you as the
owner have permission to delete the record). If the user tries to open the
table to delete records, he can't because he doesn't have any permissions on
that table.
Chris
Microsoft MVP