Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    unbound subform (97 sr2)

    I'm sooo confused. I am trying to create a subform on a main form. Usually I just drag and drop it and it works beautifully. This time, though, there is something wrong with the master/child link. It says "can't build a link between unbound forms." I don't think I've ever paid attention to bound/unbound forms.

    What does that mean? What do I look for? How do I fix it?ahhhhh

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: unbound subform (97 sr2)

    It doesn't mean what it says and you can safely ignore it. However, you'll have to set your master and child links by typing in the field or control names rather than using the wizard. Take a look at MSKB Q168872 for more information.

    It actually is possible to bind a subform to an unbound parent form, but in this case the message might also mean that Access can't recognize any possible field name matches between the forms and you don't have any relationships established that would give it a clue.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unbound subform (97 sr2)

    Charlotte,
    Is there an Index for MSKB articles? Hopefully by topic - Access 97, Access 2000, etc. Typically when I use the Search box, my phrasing does not match what Microsoft wants.

    Thank You
    Jim

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: unbound subform (97 sr2)

    I wish! Actually, I ran across a site that did something like that, but I can't remember where. I'll try to track it down on post it if I can find it.

    I usually look them up in TechNet and then search for the article number on-line in order to post the links. The search engine in the Microsoft support site is on a par with the help in Office 2000 and later--in a word, awful. <img src=/S/sick.gif border=0 alt=sick width=15 height=15> I find it difficult to use and confusing ... especially when I know the article is there and just can't hit on the right combination of keywords to retrieve it.
    Charlotte

  5. #5
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unbound subform (97 sr2)

    Thanks Charlotte,
    I too have a few terms for the Office 2000 Help, but will not/can not use them here. I'll be waiting to see if you can find the "Indexed" site, hope you will be able to.

    Jim

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: unbound subform (97 sr2)

    I've found http://www.freeanswers.com to be slightly more forgiving and certainly faster than the Microsoft support site. It's not an index, it's a search engine for the Knowledge Base.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: unbound subform (97 sr2)

    Yeah, the freeanswers engine is far better than the MS support version. But I actually ran across something else. Darn, I wish I could locate that! <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    Charlotte

  8. #8
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unbound subform (97 sr2)

    Hans,
    Thanks, this looks as it will be a very helpful site. I have it bookmarked!!
    Jim

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Index of MSKB articles (97 sr2)

    <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22>!! I found it: http://www.netfolk.co.uk/netfolk/acc...cles/index.htm. I don't know how up to date it is, but it should be helpful for 97.
    Charlotte

  10. #10
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Index of MSKB articles (97 sr2)

    See my other <!post=post,154228>post<!/post> for the link.
    Charlotte

  11. #11
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Index of MSKB articles (97 sr2)

    Charlotte,
    Thank You very much. Have looked around some on the Netfolk site and it seems as it can be very helpful.

    Thanks again,
    Jim

  12. #12
    Star Lounger
    Join Date
    Feb 2003
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unbound subform (97 sr2)

    I found the answer I was looking for in this post - I was getting the message that I can't link unbound forms. But I manually put in the field names and it seems to be working. I still have a question though. I usually put the ID field that I used to link on the form and the subform just to check that the same number shows up and it's linking correctly. In this case the number shows up on the main form but the field stays blank on the subform. When I go look in the subform table, the number is there. It's also in the subform when I open the subform directly. When I open the main form, all the information shows up in the subform correctly, with the correct main record, but the ID number doesn't show up. Any idea why?

  13. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: unbound subform (97 sr2)

    Are you sure there isn't some kind of confusion over control names and control sources?

    Otherwise, we'd have to see the database. If you wish, you can post a stripped down copy of your database. See <post#=401925>post 401925</post#> for instructions.

  14. #14
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unbound subform (97 sr2)

    You could try setting the control of your subform to a query (whose ID = ID on Main Form), and requerying the subform through your main form's OnCurrent event in VBA Code...something like

    Private Sub MainForm On_Current()
    Me!Subform.Requery

    'Or you can choose individual controls, whose record source is SQL code where ID = ID on main form

    Me.Subform1.Form!ControlName.Requery

    End Sub
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  15. #15
    Star Lounger
    Join Date
    Feb 2003
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unbound subform (97 sr2)

    I can't figure this out. Maybe someone else can help so here is the database. The main table is NewMarketingList and the subtable is subtbleRegistrantInfo. The main form is Energy Conference Registration Form and the subform is sbformRegForm. Thank you.

Page 1 of 2 12 LastLast

Posting Permissions

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