auto fill text box based on a null cascading combo box

[willfrank]

I am looking for code to auto fill a text box from a combo box selection.

Combo box selection is a cascading combo box. I would like this 2nd combo box after selection to autofill a text box.

The combo box is set up as Null, so end user can select or change on each record as necessary. thanks

[Perceptus]

In the 2nd COmbo box's AfterUpdate Event, put a reference like

textbox.text = nz(2ndcombobox.text,"")

[willfrank]

Thanks for the reference, but still not working..[

Is there a dlookup that I can use instead?

QUOTE=Perceptus;323692]In the 2nd COmbo box's AfterUpdate Event, put a reference like

textbox.text = nz(2ndcombobox.text,"")[/QUOTE]