combo box in forms

[Joe]

I am trying to creating a work order form for my
business. I would like a parts "subform" such that you
are given a combo box with all the part names in it and
once you choose what part you want all the rest of the
info would fill in automatically, like manufacturer, cost,
inventory number.... I commonly see this type of thing
done with access but I can't figure out how it is done.
Thanks

 

[John Vinson]

I am trying to creating a work order form for my
business. I would like a parts "subform" such that you
are given a combo box with all the part names in it and
once you choose what part you want all the rest of the
info would fill in automatically, like manufacturer, cost,
inventory number.... I commonly see this type of thing
done with access but I can't figure out how it is done.
Thanks

Typically you would NOT store the information about the part in the
order table at all, just the PartID. You're using a relational
database; such databases use the "Grandmother's Cupboard Principle" -
"a place - ONE place! - for everything, everything in its place".

You can display these values on the Form (without storing them) by
including all the fields you want to see in the combo box's rowsource
query, and using textboxes with control sources like

=cboPartID.Column(n)

where (n) is the zero based subscript of the desired field in the
query.