Results 1 to 2 of 2
  1. #1
    KLynch0803 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2009
    Posts
    37

    Need help with query table issue using forms

    I'm a little (Ok 3 years rusty) and need a boost to regain some memory of development please..



    I have the attached database for your review that I'm starting development on..

    I have built a form "frmQuoteProject" that has a subform that is automatically filled by using the combo's on the main form..

    In table "tblItemList" I have a column named "Height" if you notice I have values "4" or "6" or "4 6" (these are there for your reference when viewing) although represent the height of the fence that you would need this item for...

    How or what solution is there to redesign of the table or subform Criteria to make it pull al records that have the same value as "frmQuoteProject" Combo "Height" into subform "subfrmItemList"?
    Last edited by KLynch0803; 06-02-2009 at 09:11 PM. Reason: Changed method to visible & hidden preset subforms with calculations

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I see you marked the thread as Solved. Does this mean the issue is resolved for now?

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

Similar Threads

  1. Replies: 1
    Last Post: 03-02-2009, 10:12 PM
  2. Query / Forms ??
    By caljohn527 in forum Forms
    Replies: 1
    Last Post: 02-11-2009, 09:59 PM
  3. Replies: 0
    Last Post: 11-12-2008, 05:18 PM
  4. Table values in forms
    By xzxz in forum Access
    Replies: 3
    Last Post: 10-28-2008, 08:29 AM
  5. Annoying Query issue
    By stevendavies in forum Queries
    Replies: 2
    Last Post: 05-08-2006, 02:35 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