Combo Box in subform

[David Thompson]

I have a combo box in a subform which allows me to select a number of parts, and I get the description of the part in the next field with a DLOOKUP - all OK.
BUT I need to be able to edit the part description on odd occasions without permanently changing the original part description and a filed bound to the dlookup wont let me edit it.
Any clues to fix this problem, an alternative to DLOOKUP maybe?

Thanks

 

[Jack Cowley]

If your combo box gets the Part Number then you can also have it get the Description as well. Then in the After Update event you can use code like this to put the Description in an unbound text box:

Me.UnboundTextBoxName = Me.ComboBoxName.Column(1)

The above assumes the Part Number is in the first column in the combo box and the Description in the second....