>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.

What are you going to do when requirements change in the future to store 6, 7, 8 ... medications per client? You shoud normilize table structure and store medications one per row in the separate table linked to the client table by client ID.