Results 1 to 3 of 3
  1. #1
    funkstrong is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Oct 2011
    Posts
    2

    Form with multiple subforms, many prompts


    Hi everybody, hopefully I am explaining this correctly. Might have gotten myself in over my head, haha. I have a form with 3 subforms in it. My main form and all of my subforms are based on a query which prompts the user to enter a Customer Id. When I open the form I of course get 4 prompts to re-enter the Customer Id while it populates each form. I know I could display all the date on one big form without using subforms but to properly organize it I like the tabbed subforms. Is there an easier way to do this so it only prompts for the customer ID once? Thanks!
    Last edited by funkstrong; 10-12-2011 at 11:42 AM.

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    I have a similar situation.

    My main form is opened with a key field supplied, e.g. account number. The account number and other basic information appears on the main form. The subforms each have queries that reference the account number on the main form. The most difficult part of this is getting the syntax correct on the references.
    Also...I haven't tried just opening the main form and having it ask for an account number. It may be that having the account number available when the main form opens (the 'open' event) is necessary to prevent the subforms from asking .
    Try it and let me know if it works. If not I'll try to duplicate your setup.

  3. #3
    funkstrong is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Oct 2011
    Posts
    2
    Thanks for the info. I created new subform queries based on the customerID in my main form and it works! It asks for the initial customerID and then the subforms load by themselves. Quick and easy fix, thanks for saving my brain the trouble haha.

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

Similar Threads

  1. Replies: 22
    Last Post: 03-15-2011, 07:17 AM
  2. Replies: 0
    Last Post: 02-28-2011, 09:46 AM
  3. position multiple subforms
    By Mclaren in forum Programming
    Replies: 1
    Last Post: 07-12-2010, 08:52 AM
  4. Replies: 1
    Last Post: 06-02-2010, 10:05 AM
  5. Display and Empower Multiple Subforms
    By Schwagr in forum Forms
    Replies: 2
    Last Post: 03-28-2006, 03:51 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