update a text box from a combo box

[Burghew]

Hi all,

I have 3 unbound combo boxes in my form which basically helps me to filter
for values. I need to update a text box which will be stored with the value
I receive after filtering with the combo boxes. I know of the column(n)
method (derived from the third combo). However if the user does any sort of
manipulation in the first or second combo then the value in the text box
doesn't change accordingly. Is there any other way to update the text box in
a more accurate way. Please help. TIA

 

[Jeff Boyce]

Are you saying that any change to any of the three comboboxes requires a
re-evaluation of what belongs in the textbox? If so, consider using the
AfterUpdate event of each combobox to re-evaluate and re-fill that textbox.