Im fairly new to the World of Access so this might be a completely stupid question ...
What I have is a form with a combo box that has as list that pulls from a table that I update. Sometimes, a number repeats (Number) but with different information (for example, costs).
What I was wondering was is there a way that I can have the Number chosen in the combo box list and have all the costs that are conntected to that number show up below in the Detail section?
For example:
------------------
Number (selected in combo box): 123456
------------------
Costs:
$1.21
$2.21
$3.21
Any help is greatly appreciated!!!
What I have is a form with a combo box that has as list that pulls from a table that I update. Sometimes, a number repeats (Number) but with different information (for example, costs).
What I was wondering was is there a way that I can have the Number chosen in the combo box list and have all the costs that are conntected to that number show up below in the Detail section?
For example:
------------------
Number (selected in combo box): 123456
------------------
Costs:
$1.21
$2.21
$3.21
Any help is greatly appreciated!!!
