Deleting a Record from a Form

[Allan]

I am working in A2000 and consider myself a novice Access user.

I have one form in the d/base with a subform imbedded. The form derives the information from a query getting information from two tables (One main table the other a town/postcode table).

When I delete a record from the form the record will disappear but remains in the main table, reappearing obviously when the form is reopened.

I have other databases where the delete button removes the record from the underlying table and I have checked all the Form Properties etc against the "offending" D/base but cannot identify any obvious differences. Can somebody point me in the right direction please.

Thanks

 

[Autoeng]

Hope you saw this post. Perhaps it will be of some help.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=45955

 

[Allan]

Tks. Had not seen that question and responses but there were others along the same lines but could not provide me with answers.

There is a one to many relationship and I have checked the cascade delete.

Still a mystery to me.

 

[Allan]

Sorry for the bother - operator error.

During a process of elimation (by starting at the beginning) I found in the query for the main table used in the main form, I had inadvertantly included the table used to store the information for the subform, thereby duplicating it with the sub form query.

Lesson learnt to check my work before posting a question.