Deleting Records via a command button and via menu

[Poem]

Have created a tabbed form.

I am trying to delete a record, it appears to delete OK get the message 'You are about to delete a record ....etc'. It then disappears off the forms recordset, but when then coming out of the form and going into the table or re-entering the form, the records are still there.

I can however delete it straight from the table, I have deleted all the relationships to the table to see if it may be something to do with that, but no luck

Has anyone got any ideas what is happening.

 

[psemianonymous]

It depends on where your focus is currently set. If you are using subforms and the delete button is on a subform, it will delete the subrecord (the record on the subform).


If you want to delete the main record, manually set the focus to the main form, then do the delete process. For additional kicks, replace Microsoft's crazy code with:

If Not Me.NewRecord Then
    RunCommand acCmdDeleteRecord
Else
    RunCommand acCmdUndo
End If

If the above isn't your problem, then I don't know what's going on. Obviously it's deleting something.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Poem]

Hi there, thanks for the reply
Yeh.....I have created a form with multi tabs, this contains two tables information, one for the candidate details, the second one containing their course details.

When, trying to deleting the candidate, it deletes the course details but not the candidate details, these two tables are joined one to many. with cascading deletes