Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    forms and subforms (Access XP)

    Hello again,

    This time the question that I have is this. I want to create a form to build recipes of menu items. On this form I envision subforms. The main recipe form would have the recipe number, name, cost of ingredients, comments. Along with other control buttons I see "Add" and "Minus" buttons. With these buttons the operator could add to a highlighted recipe (this would take you to a form that shows the breakdown of the ingredients. This "build the recipe form" would have at least two windows listing the 1. the recipe, 2. the ingredients available to be added to the recipe. I would like to have control buttons similar to the "add single", "add all" buttons in the query wizards. The right and left arrows that you use to make the item from one window jump to the other.

    This is just a start but I wanted to get some opinions of difficulty/workablility of this idea first.
    Here are my questions, 1. Is this possible with subforms? 2. Is is something a "novice" should even attempt?

    Any ideas and advice will be greatly appreciated.

    Bret

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: forms and subforms (Access XP)

    1. I think I would lean towards (multi-select) list boxes instead of subforms. It is easier to get at the selected items in a list box then to determine which records in a subform are "selected". Look up the ItemsSelected and Selected properties of a list box.
    2. To be very blunt, I think it would be a tough job for a novice. That doesn't mean you shouldn't try it, but be prepared to get stuck often and become very frustrated if you do.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: forms and subforms (Access XP)

    Thanks Hans,

    I'll give try your suggestion. As long as I have all of you to lean on my frustration never lasts very long. Thanks so much for all the help you and the others give on this board it is great.

    Computers are one of the few areas left that people seem to honestly love helping each other.

    Bret

Posting Permissions

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