Requerying a list box based on a combo box selection

[Dannyboy11]

Hey

I have a form that has a combo box that displays referees from a query of whether they are registered or not, and then I have a list box of all available dates throughout the season so I can input when they are free to referee.

1. How can I do this by making it a multi select list box? When I made it multi select, my query did not add any available dates to the table. I don't know how to overcome this as each available date is a separate record, and the query will just append whatever available date id to the table.

2. Even if I just use my current method, how will I go about creating a unmatched query as I do not want the list box to display dates that the referee already has available (for ease of use really and to prevent you adding the same date twice as it'd be pointless)
​

 

[The_Doc_Man]

This is clearly a case for cascading combo boxes.

I think your problem is that the records for available referees are in too many levels.

What you describe, combo-box to control a list-box, is commonplace. But the fact that you have child records for the referees' availability dates tosses a monkey-wrench into the works.

What you describe also vaguely resembles the same kind of idea that is used when booking rooms or making reservations based on availability. Search this forum for the topics "Bookings" and "Reservations" and "Scheduling" - but be warned that "Scheduling" will also bring in how to schedule Access itself to do something using Windows Task Scheduler, which might not be what you wanted. The other two keywords should be better at filtering out extraneous entries.

 

[Kryst51]

Hey Doc Man, here is more on what he is trying to do. I didn't think it would be too hard to do what I suggested at the bottom of this thread, the only difference would be adding records to a junction table right?

 

[Dannyboy11]

Hey Doc Man, here is more on what he is trying to do. I didn't think it would be too hard to do what I suggested at the bottom of this thread, the only difference would be adding records to a junction table right?

Hi Kryst. I didn't realise you had posted an update to that thread so my apoligies for not responding to it.

 

[Kryst51]

Hi Kryst. I didn't realise you had posted an update to that thread so my apoligies for not responding to it.

No problem, I actually thought you had looked at it but were having problems with my suggestions. No worries...