Results 1 to 3 of 3

Thread: Deleting a record from a child-table (ADODC)

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2001
    Location
    Sweden
    Posts
    10

    Question Deleting a record from a child-table (ADODC)

    I am trying to create a small simple applikation in VB 6.0 that connects to an Access 2000 database. Everything works, except when i´m trying to delete a record from a child-table.
    I have created a cascade on delete from the parent-table, and it works without any problems.
    When a deletebutton is pressed the following function is called:

    Function Delete_Snake (dat as ADODC)
    Dim YN as Integer
    YN = MsgBox ("Warning! Do You really want to delete this record?", vbYesNo+vbCritical,"Warning!")
    If YN = 6 Then
    dat.Recordset.Delete
    End If
    End Function

    There is no problem deleting a child-record within Access.
    Rem. I have 5 ADODC "children" controls on the same form and one master. I don´t have any problem in inserting new records to the children...

    Please help....

    P.S.
    I´m using textboxes for displaying the attributes (including PK)
    D.S.
    Last edited by Nurse; May 22nd, 2001 at 05:52 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width