forms and subforms (Access XP)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote