Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2003
    Location
    UK
    Posts
    78

    Unanswered: linking subforms on a form

    is it possible to link two subforms on a form:

    I want subform 1 to link to the main form and subform 2 to link to subform 1.

    I have no problem linking subform 1 to main form, but I cant link subform 1 to subform 2

    any ideas?
    the light is on, someone is home, but they dont know they are. HELLO!

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    Have subform 2 already linked to subform 1, then link subform 1 to the main form. I think the second subform is the deepest level you can go.
    All code ADO/ADOX unless otherwise specified.
    Mike.

  3. #3
    Join Date
    Aug 2003
    Location
    UK
    Posts
    78
    Originally posted by HomerBoo
    Have subform 2 already linked to subform 1, then link subform 1 to the main form. I think the second subform is the deepest level you can go.
    Thanks. Do you know if i can tell which record is selected on a subform.... if i can get that then i can do the rest sql etc
    the light is on, someone is home, but they dont know they are. HELLO!

  4. #4
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    Try using the OnCurrent event of the subform.
    All code ADO/ADOX unless otherwise specified.
    Mike.

  5. #5
    Join Date
    Aug 2003
    Location
    UK
    Posts
    78
    Originally posted by HomerBoo
    Try using the OnCurrent event of the subform.
    interesting, I will explore this option, thankyou.
    the light is on, someone is home, but they dont know they are. HELLO!

  6. #6
    Join Date
    Nov 2003
    Location
    New Zealand
    Posts
    47

    Smile

    Hi i am trying to link three subforms on a form subform 1 to the form subform 2 to subform 1 and subform 3 to subform 2.

    when you say the subform 2 is the deepest level does that mean i can't have subform 3 link to subform two....ect?????

    Bugger.....if so any ideas how i would go about displaying the last options in subform 3.

    thanks for you help.
    nerdy_girl
    Nerdy Girl

Posting Permissions

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