Combo Box filter not showing values

[Chatholo]

Hi everyone,

Not sure if anyone has run into this problem, I am using access 2010. I have a subform with combo boxes. I was hoping to filter through each one of the boxes to help with the selection of data but, when I click on them the list with the usual boxes ticked don't show ...
Anyone would know what to do to fix this?

[TG_W]

Are you trying to set up cascading combo boxes? i.e., select first combo box which limits your second which limits your third and so on.

[Chatholo]

Hi TG_W,

I am but I haven't done a post for that yet!
This post is only questionning why we can't see the littles boxes that can be ticked when we usually do a filter. I have another database and it works very well, but for whatever reason - which I a am trying to find out, when pointing/clicking my mouse onto the top right hand corner of the combo box I can only filter the "old fashion way" as per the screenshot. And do not have the option of the "ticked boxes".

Would you know why?
Thanks in advance for your help!
C.

[TG_W]

I get what you are asking for now. Mine disappear every so often, and it usually has to do with how many rows of data I have. If I have 20,000+, I don't see them. I think it's an Access quirk, unless someone else out here knows what might be the issue. You might consider adding adding a 'Yes/No' Field and a subform next to the table in the main form that has a 'Group By' query on [Market]. When the Form and Subform load, have an 'On Load' event that selects them all automatically, then an 'After Update' that de-selects the records.

Or

You can have an 'On Load' event on your form that deletes then appends a secondary table with just two fields - [Market] and [Select]. The [Market] would populate from a 'Group By' append query when the form loads. You would then use the secondary table to select and de-select.

I can post an example of what I just recently built for a reporting database where I did something similar, except I populate the secondary when I import the data. I would just need some time to strip it out.

In the mean time, I have attached a sample database with cascading combo boxes I have in the tool chest.

[Chatholo]

Thanks a lot for your response TG_W. Yes I do have more than 20,000 rows... that explains it. I understand the grouping that you describe, but I alreasy have a form and a subform, I am not sure I can create multiple subforms. I will give it a try, unless you know if there is any other options.

Thanks for the combo as well. I manage to do that one
C.

[TG_W]

I don't really know of any other way. I have attached the current database I am building that is similar to the process I was talking about with setting the filter parameters in a different table, but that is performed when I import data. All I do is run a 'DoCmd.OpenQuery' on an append query after performing a delete with a 'DoCmd.RunSQL' in the import coding, so the same could be done when opening a form. The "Report Menu" is where you can see the select and de-select in action.

Hope this helps.

[Chatholo]

Thank you very much TG_W. Your posts were very helpful

[TG_W]

You're quite welcome. Glad I could help!