I have 5 Combo boxes saving 5 different medications a client takes to a table with the respective fields meds1, meds2, meds3,.. I need each combo box to have a Rowsource type of "SQL statement" that is sorted and includes values from all the five fields in the table as one. That is, one combo box is able to highlight all medications taken irresepctive by where the field it is from.
I guess this is possible and would appreciate help from any of the gurus.