Results 1 to 4 of 4
  1. #1
    WesHarding is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Posts
    60

    One-to-many data in a continuous form: ways around this?

    Hi All,

    I currently have a database that works to search through farmer records based upon typed parameters by the user (name, etc.). Each record in this continuous form has a "Detail" button which redirects the user to a form containing further information such as commodities. However, my boss keeps insisting that I put commodities on the initial record.

    These commodities are are-to-many, as one farm can produce many things. I know from the past that I had zero luck getting a subform into a continuous form. So I am curious if anyone has tried tackling the issue of populating a continuous form with one-to-many data. Any advice would be greatly appreciated, as I don't really know how I'm going to handle this predicament.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you CANNOT put sub forms in a continous form.
    Your design is correct, pick from the list (continous) goto Detail.
    Add subForm items in the single record detail form.

    Managers and VPs always want to do things bass-akwards.

  3. #3
    WesHarding is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Posts
    60
    I actually really like the way I have this designed too! It all comes back to their desires to see it "in an excel spread sheet"... Oh well. I'll re-confirm this information. Thank you ranman256

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Quote Originally Posted by ranman256 View Post

    you CANNOT put sub forms in a continous form.
    Sure you can...you just have to fool the Access Gnomes!

    The workaround for having a Subform when the Main Form is in Continuous View requires that you put the Subform either in the Header or the Footer of your Main Form. To escape the wrath of the Access Gnomes you have to:

    • Create your Main Form in Single Form View
    • Place the Subform in Header or Footer, whichever you like
    • Save the Form
    • Now go into Properties and change the Main Form's Default View to Continuous View

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Replies: 4
    Last Post: 06-02-2016, 09:03 AM
  2. Continuous Form vs. Data Entry
    By Paul H in forum Forms
    Replies: 2
    Last Post: 11-30-2015, 01:18 PM
  3. Replies: 7
    Last Post: 09-04-2013, 03:28 PM
  4. Form Using Data Entry Both Ways
    By 95DSM in forum Forms
    Replies: 4
    Last Post: 07-27-2011, 02:17 PM
  5. Ways of preparing data for graphs
    By ajetrumpet in forum Queries
    Replies: 0
    Last Post: 09-11-2010, 10:26 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
  •  
Other Forums: Microsoft Office Forums