moshea444 wrote:Is there a way to have a list box have all results selectable no matter what other selections have been made.
That's how list boxes work. They do not prevent you from selecting gray values. Is there a problem when you select gray values? I'm not sure what you're really asking.
Yeah I get that's how list boxes work i just have a weird case where a list box of months is linked to a table but i don't want the months to ever be grayed out even if other filters are selected. I want to do this because I have another table with a months field that i want to use the same calendar list box. If selecting gray still works than thats fine but I would like it to turn green and act like it's selected. Is that possible?
You have a table, let's say of orders. You select a particular product that was ordered, say pencils. There were no pencils ordered in September, so September is grayed out. Now you want to select September. That's fine, it should work, and it should turn green and act like it is selected because it IS selected. However, the product selections of pencils will disappear. It does not make any sense to look at September and pencils at the same time, because there is no such data. You just asked to look at September, so that overrides the older request to look at pencils.
I'm also a bit worried about you saying you have two tables linked to the same calendar. While I'm sure there are good data models that do that, I see a lot more bad data models that do that. So it doesn't mean you've done anything wrong, but it worries me, particularly in combination with you reporting problems making the selections you want.
But I'm probably still not understanding the problem you're having.
