Filtering Question

[cbende2]

How do I get the second filter to show all the values and allow me to check which ones I would like to select? I cant seem to recall how to do this. I remember having to do it a while back, but it's slipped my mind.

Thanks guys

[June7]

Are you clicking the Filter button on the ribbon?

[cbende2]

Yep in both instances

[June7]

The second one looks like a combobox on form or maybe a lookup field in table.

I did a test with several comboboxes on form, all are 1 column. One of them doesn't show list, all the others do. I don't know why that one is acting different.

I also tested with textboxes, they all show the list.

I tested a textbox bound to the same field as that one combobox and that does not show the list.

Sorry, I am baffled.

[cbende2]

Its ok, thank you for looking into it June7! I'll leave the thread un-marked, that way if I ever find an answer, I can resurrect this post with an answer!

[June7]

More about my test. Think I found the issue, at least with my db.

The form has a query as RecordSource. The query joins primary table with another table so related info can be displayed (but not edited). Then I also have a combobox that has RowSource pulling list from the related table. Both tables have a field with same name as the other (the PK/FK linking fields - these are text, not autonumber), although only the one from primary table is pulled into query. The combobox is listing values from the PK field of the related table. I am not saving ID, I am saving descriptive text.

Either of the following options fix the issue:

1. change name of one of the fields

2. remove the related table from the form RecordSource
change combobox to multi-column to pull in related info and textboxes refer to the columns to display - however, cannot use these textboxes to filter records

I went with option 1.

[cbende2]

So changing the names to have them NOT Equal fixed this for you? so instead of [PlanID] = [PlanID] make it [PlanID] = [IDPlan] ??

[June7]

I changed the field name in the related table from District to DistrictID. The name change propagated to the combobox RowSource SQL and the form RecordSource SQL. All works now.

[cbende2]

Gotcha, sounds good, I'll give it a try.