Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    5

    Unanswered: delete a record on a subform?

    HI, can anybody help me out?

    I have a subform on a main form. the subform is in datasheet view. I am trying to delete the current record on a subform using VB, or delete those records on a subform selected by users. can anybody give me some suggestion? Thanks a lot!!!!!!!!!!!!!!!!

  2. #2
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    currentdb.execute "DELETE FROM MyTable WHERE MyID = " & Me.MySubformControl.Form.MyID & ";"

    should do the trick, requery the subform afterwards to the get rid of showing the row as #DELETED

Posting Permissions

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