Results 1 to 6 of 6
  1. #1
    Mihu is offline Novice
    Windows 11 Access 2021
    Join Date
    Jan 2025
    Posts
    1

    Ungebundenes Unterformular

    Ich habe ein ungebundenes Unterformular in einem Hauptformular. Das Unterformular hat eine Abfrage als Datenbasis, in der neben dem Datensatz des Hauptformulars weitere Datensätze enthalten sind.


    Wenn ich das Unterformular isoliert öffne, erscheinen alle relevanten Datensätze, wird es Unterformular im Hauptformular geöffnet, erscheint nur der Datensatz des Hauptformulars. In den Verknüpfungseinstellungen sind beide Felder leer.
    Wo habe ich da einen Fehler bzw. Trugschluss?
    Danke für Tipps

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    Non comprende. Lo siento.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Quote Originally Posted by Mihu View Post
    I have an unlinked subform in a main form. The subform has a query as a data basis, which contains other data records in addition to the data record of the main form.
    If I open the subform in isolation, all relevant data records appear; if the subform is opened in the main form, only the data record of the main form appears. In the link settings, both fields are empty.
    Where am I making a mistake or misconception?
    Thanks for any tips
    Can you post a copy of the db. No data is needed.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    I could swear that is a crosspost, but cannot find it now.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    Maybe either post 5 or 6 here might be relevant
    https://www.accessforums.net/showthr...257#post530257
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    jojowhite's Avatar
    jojowhite is offline Competent Performer
    Windows 11 Access 2021
    Join Date
    Jan 2025
    Posts
    433
    on design view of your main form (with subform).
    click on the subform and make sure that a "Yellow Orange" band surrounds it.
    then goto Property sheet->Data, and inspect the Link Master Fields and Link Child Fields and make sure to
    delete anything on it.

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums