G
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
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