problem in deleting records of a table via its form

[ahmed sami]

Hi everyone...I have created a database in access 2007 that contains one main table, this tables is controlled via a form. Via this form, I have put a command
buttons by which I can open another forms based on another tables. The problem is: The other forms that are opened via the form cannot delete records of there


tables...whereas the first form has no problem in doing so. Is that because I have many fields in each table? If any one has an idea, please help.

[ranman256]

You CAN delete records from the form that shows them.
If you are getting a message about CANNOT DELETE, then your query could be incorrect.
(unless you have some special locking turned on)

Another option would be to have a form that is NOT linked to a table , and 1 delete button, and a combo to pick table, and pick criteria.

[alansidman]

It is generally not a good idea to delete records in a database. Rather, add a field to the table and bound form to identify it as archived or some other term you prefer. In your queries and reports, you can then exclude those records that have been "archived." My 2 cents.

[June7]

Are you able to do other edits on those forms?

Agree with alan - deleting records should be rare event.

[ahmed sami]

Thank you for reply...I want to clarify some points:
1. No message appears that inhibits deleting record. Rather, the records get deleted temporarily, then appear again once I reopened the form.
2. The objective of the database that may need deleting records, especially in case of wrong entry, or in case of removing a whole record. Ok, I can go on without deleting whole record by removing it field by field, but it is rather tedious process.

[June7]

1. Weird, never seen that and no idea what is happening. Would have to examine db.

2. I understand wanting to eliminate a bad input (I manage this at data entry, they better be sure they want to save this record) but removing a record that was valid at one point seems dangerous.

[ahmed sami]

It is really weird. However I am trying now to get around this problem by finding another way to complete the design. I don't know may be decreasing the number of fields...or by eliminating combos from the other forms.