thanks for the input,

When I run it an error comes back as "Compile Error: Method or data member not found for "Me.ComboBoxDeterminingColumn.Value"

I tried a couple of codes in ComboBox1 to state the column but could not get it to work.