Combo lookup entries disappear after no longer in query

[mightyatom13]

I have a database that tracks advertising for concerts by the ad. For instance, one newspaper ad will have several concerts in it. I have a form that has the ad and a subform that lets you pick the concert and the percentage of the ad. I have a combo box listing upcoming concerts that is drawn from a query that sorts all of our shows by todays's date, listing only upcoming shows. It selects from a field called ShowID but displays the band and date (two other fields). Once the date of the concert is past, it has blanks where the band and date used to be (although on the table it still lists the ShowID). It is no longer able to look up the band and date based on the ShowID because they are no longer in the query (because the date is passed). Any ideas on how to get it to retain these or tell it to look at the tblShow that the UpcomingShows query is drawn from?

Thanks,
Jeff