I am trying to create a Standard Module to update a textbox on two
seperate forms based on the selection of a combobox in a main form.

I need for each of the smaller forms to check the selection of the
combobox, and then show results of the second column of the combox
based on what the user chose.

I have tried the combobox.Column() method with an if.. then.., and
if.. then.. else.. statement in the afterUpdate, and OnChange event
dialogue to no avail.

Please help.