Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    4

    Unanswered: Form with combo boxes that values are repeated, HELP

    This will probably be very easy for someone but I'm new at this. I have created a form with four combo boxes on it and a subform that I want to show the results of the combo boxes. It's hard to explain, so I will start at the beginning.

    I have 5 tables. Line, machine, bowl, lane, and guage.

    Each is related by a unique ID. Line to machine, machine to guage, guage to bowl, bowl to lane.

    On my form, I have 4 combo boxes. One for Line, one for machine, one for guage, and one for bowl. Once each of these have a value selected I want the values from the lane table returned in a subform.

    The problems I am having is that the values in the combo boxes are all repeated except for the line. There are 3 lines. Each line has 2 machines. Each machine has 3 bowl, and each bowl has 15 lanes. I would like the combo box for line to show the values, "1, 2, or 3". For the machine, "machine1, or machine 2", for guage, "1, 2, or 3", and for bowl "1, 2, or 3".

    The values that show up are 1,1,1,1,1,1,1,1,1,1,2,2,2,2,2,3,3,3ect.

    I can create the combo box with a list value of my choice, but how to I use this to filter through the table. Also, how do I get the subdata to return from the values entered in the combo boxes?

    I am lost, any help would be great. Here are screenshots of what I have: http://home.neb.rr.com/gpkps/rela.gif
    http://home.neb.rr.com/gpkps/tool.gif
    http://home.neb.rr.com/gpkps/tables.gif

    [IMG]http://home.neb.rr.com/gpkps/rela.gif[IMG]
    [IMG]http://home.neb.rr.com/gpkps/tool.gif[IMG]
    [IMG]http://home.neb.rr.com/gpkps/tables.gif[IMG]
    Last edited by Access guru; 04-07-04 at 17:29.

  2. #2
    Join Date
    Apr 2004
    Posts
    4

    got it on my own

    Well, I figured someone would at least try to help me, but I guess as they say, shoine bien, es tu. You have to help yourself.

    What I was doing wrong was everything. My tables were bad, I needed to use several queries use a subform with a query to update. The form works great now.

    Access Guru

  3. #3
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    LOL give us a little time. I just started reading your post. :-P

    Glad you figured it out be cause I wouldnt have been able to help.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

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