hello again..
I have a form linked to a query.
when the form opens its asks for a part number
it takes the part number and populates the form with a bill of material (a list of parts).
What I'd like is when a part number is clicked on from the list that part number is then passed back to the form/query. that way people can drill down through parts lists without having to manually type in a new part number.
I've gotten the control but im unsure how i pass this back to the form again?
[Forms]![frmBomViewer]![PART]
I have a form linked to a query.
when the form opens its asks for a part number
it takes the part number and populates the form with a bill of material (a list of parts).
What I'd like is when a part number is clicked on from the list that part number is then passed back to the form/query. that way people can drill down through parts lists without having to manually type in a new part number.
I've gotten the control but im unsure how i pass this back to the form again?
[Forms]![frmBomViewer]![PART]