> > Ken, > Thanks for the assistance. I forgot to state that there are multiple comboboxes on form 1. Which interact with various form 2's. ie. a brandbox, a vendorbox, a conditionbox, etc. Where should the statements be placed. > Thanks
Just put it all in the same place ... or if you are selecting a value
from one combobox on one subform, then do the code like I showed in the
previous post for that one combobox, and then for another repeat but
with the correct references ...