Filter Form

[DingDong]

Hi there,

I have a problem with my search(filter) form. I've created an Form with a subform.

Form - Search/Filter subform by string (text)



As now I have created an dropdown box with 2 options: "CheckON and CheckOFF".
The thing I want is that the subform refreshes the people who are checked and unchecked when highlighted.
If you download the attached databases you can see at tables "Deelnemers" that every individual has an checkbox row.

I can't seem to figure out how to do this.. So please do help

[June7]

I would not use form/subform arrangement. I would use a single form in Continuous view and arrange controls to appear as datasheet with the search textbox and buttons in form header/footer sections.

The Check field is not in the form RecordSource. Can't apply filter to a field if it's not included in RecordSource. Instead of referencing the query object, just reference the table.

CheckOn and CheckOff are string values, not Boolean. Why does the combobox use expression Naam(Voornaam)=Me.Dropdown instead of filtering on the Boolean field?

strF = "Check = " & IIf(Me.Dropdown = "CheckOn", True, False)

[DingDong]

Thanks for your help but I've tried it but I can't seem to get it to work.
See my attachment, please

[June7]

What doesn't work?

I tested the dropdown and it filters the subform.

[DingDong]

What doesn't work?

I tested the dropdown and it filters the subform.

That's odd it doesn't work for me X_x

From the dropdown list I choose CheckON but it doesn't filter the people who are checked.

Not on acces 2010 and not on access 2003

[June7]

All I did was download your latest db and it works as is.

[DingDong]

All I did was download your latest db and it works as is.

When I choose CheckON I get a box:

"Enter Parameter Value
true

"

Then I need to enter something, please I need this fixed. Because it doesn't work for me


I want:
When I choose CheckON that it filters all the people that are Checked (database, deelnemers)
When I choose CheckOFF that it filters all the people that are NOT Checked (database, deelnemers)

[June7]

I did it again. Downloaded your database, opened db, selected value in combobox, records are filtered.

If you are performing a different sequence of actions to produce error, what are they?

If I can't replicate error, there is nothing for me to fix. I don't have Access 2003 so don't know why this fails for you.

[DingDong]

Weird enough, I'm doing the same thing, same sequence. When I choose CheckON theres a box popping up saying "Enter parameter value".

Tested on access 2003 and 2010(x64)

[June7]

Weirdness often means corruption and I would suggest deleting the combobox, run Compact & Repair, and create new one but since the combobox works for me, I am at a total loss for an explanation and solution.