I have one form frmShows with a many to many of show prices for years.
Year 2012 (combo box) has $4.70
Year 2013 (combo box) has $4.40
These values are stored in the many to many junction so that each show can select the year and the price for that year. That works fine.
I have a bookings form which selects shows then does a d-lookup for the show prices - I did this before I added the junction. The reason I did a d-lookup is that I needed to store the values at that time - the show price wouldn't affect the booking if it changed. Just something that was needed.
The next task is to have a combo box select the year on the booking (i.e. what year they are going to book, this year or next) and then filter the shows according to if the year matches if the shows have a price in that year.
The goal is that when you select a year on the booking form then only the shows with a price for that year will show in a combo box for that chosen year.
So 2012
gets Show A
with 2012 Price
but
2013
gets Show A
with 2013 Price
I can't have 2012 shows showing in 2013 shows either in case there isn't a price placed in the show table and vice versa.
I'm guessing something with if show year = to show year price then only show shows with show year price but not sure how to put in vba....