Setvalue from record value

[Guest]

I have a combo box that shows 2 colums; partname & part#. On the change
event of that combo box I will create a macro or code to setvalue to 8 other
controls on the same form using dlookup. I'm looking up values in the same
table that the combo box is looking up it's values. My problem is that there
may occasionally be two of the same partnames & partn#'s in the combo box so
using dlookup won't help. I will count on the user picking one of the two.
How can I set the values of the other 8 controls to the values in the record
selected via the combo box? I hope that makes sense. Thanks

Alex

 

[Guest]

I will use the combo box to filter a subform and there is a lot of help in
the newsgroups on that so I'm all set. Thank you.