I am using a combo box to select data that will update a field on several
pivot tables to keep them synconized. ie one tabel is Month and the other is
Year data. What happened is I have history in the Year data for an item and
no data in the Month data. How can I return data in the Year table and a
message in the Month table that there is no data available?