Is it possible to select the same item twice using a MultiSelect List Box

[Watergirl]

I would like to be able to create a recipe (saved in its own table) by pulling items from a multiselect list box (from the raw materials table) but which allows me to add the same ingredient more than once.

I work for a chemical manufacturing company and we need to track the cost of goods by recipe (final product), by linking the ingredients (where the cost of the raws are associated) to the final prodcut. Several of our products need to have chemicals added in the beginning, but then again at the end of the procedure unlike normal kitchen recipes.

(I sure hope I don't have to learn VBA . . . I'm totally new at Access!)

Thanks in advance for your help.

 

[WayneRyan]

WaterGirl,

Just a thought, but maybe you'd be better with a subform instead of
a ListBox. It could offer the advantages of controls like CheckBoxes
and a quantity field.

Wayne

 

[Watergirl]

If I use a subform (I'm assuming with a combo box), would I be able to choose more than one item, and be able to choose one item more than once? And then can the subform be used to create a table?

Pam

 

[ByteMyzer]

It sounds more like you are in the market for an MRP application (Bill-Of-Material/Work-Routing based system). Something like this would allow you to specify how much of which "ingredients" are added at which point.