Combo boxes in forms

[kong]

Hi guys.
I'm pretty new to Access but I have picked up the information pretty fast since I have worked a little with mysql, javascript and others as well. I'm having trouble displaying some information the way I want it to.

First part - In the combo box I'm wondering if I can display "ALL" columns even "after selecting" it. Example: Part Number, Parts Description, & Cost all show up even after selecting. I am able to get them to all to display in the combo box but after selecting it the main ID would only be the one to display.



The second part - With a many combo boxes, I would like to be able to select many Part Numbers without it being duplicated. This is kind of like a multi-level bom. So I would have a finished product with many parts. I have tried and they all get duplicated to the other combo boxes. Do I have to create a unique field for each part in the finished product?

Thanks in advance.
K

[ranman256]

Combo boxes only show 1 item.
you CAN fill unbound boxes after the selection, via AFTERUPDATE event

Sub cboBox_afterupdate
TxtName = cboBox.column(1)
txtAddr = cboBox.column(2)

end sub

[orange]

kong,

You may get some ideas from this post.
As for multi-level, you may be dealing with Cascading Comboboxes. I'm not sure of your context.
If you are selecting many items and processing further, I think you need to research Listbox(es) which can be multi select.

[CJ_London]

The second part - With a many combo boxes, I would like to be able to select many Part Numbers without it being duplicated.

not sure if I've understood correctly but you can investigate using multivalue fields in your table for a bound combobox. However they are relatively limited in use and can have other issues (for example cannot be indexed so will slow performance) so may not be appropriate, what you probably need is a link table which links your item table to your parts table

[kong]

Thanks guys. I will take a look at those options you have listed. It might be a combination of those. I'm not sure yet. Here is more details.

tblParts
-PartNumber
-Description
-Cost

tblFinishedProduct
-PartNumber
-Description
-Cost

They are both in a many to many relationship. I'm creating a form for the Final Product that will include multiple parts with it's related description and cost to have a final cost for that finished product. Hopefully that's more understandable. I will try out the cascading boxes and list. So the form would look something like this.

Finished Product Part Number
Description

Part 1 Description Cost
Part 2 Description Cost
Part 3 Description Cost
Part 4 Description Cost
Total Cost

[orange]

kong,

Again not sure of your business context, but you mentioned multi-level BOM, so this article may help.
Or this one.

If you have a more complete description of what you are trying to do, it may help readers.