Button to update criteria

[Master Klick]

Help2.zip

Above is a sample of my databse. In the form there is a "Qty" button. It is suppose to, when clicked, toggle between showing all items and only items I have in stock (showing >0 qty).
I had it working in other databases but it will not function in this one. I have no clue why.

Any ideas? I'm sure it's probably something stupid, it always is.

[June7]

The button is running an UPDATE sql. An UPDATE sql is to modify data in table, not set filter criteria.

Why are you using a listbox instead of just setting the RecordSource of form to the SQL and use code to set form Filter property?

Why pull so many fields into the listbox RowSource?

[Master Klick]

The button is running an UPDATE sql. An UPDATE sql is to modify data in table, not set filter criteria.

Why are you using a listbox instead of just setting the RecordSource of form to the SQL and use code to set form Filter property?

Why pull so many fields into the listbox RowSource?

That's how I was about to get it to work. I am an amateur at this. Most of that database I put together by picking apart other databases and just figuring out what different pieces of code and whatnot basically do. I think I've don't pretty good considering how far I got without any actual training. And it still works. Does exactly what I need it to do. I just can't get that one button to work.

[June7]

It doesn't work because you are using the wrong SQL. The listbox RowSource should be a SELECT not an UPDATE.

[Master Klick]

It doesn't work because you are using the wrong SQL. The listbox RowSource should be a SELECT not an UPDATE.

I don't understand, the rowsource says "SELECT InvQuery.ID, InvQuery.Qty, InvQuery.Name, InvQuery.Edition, InvQuery.Color, InvQuery.[Card Type], InvQuery.[Card Subtype], InvQuery.[Image Path 1], InvQuery.Power, InvQuery.Toughness, InvQuery.Loyalty, InvQuery.CMC, InvQuery.[Mana cost], InvQuery.[Mana Gen], InvQuery.Rarity, InvQuery.[Price Low], InvQuery.[Price Mid], InvQuery.[Price High], InvQuery.Artist, InvQuery.Ability, InvQuery.[Flavor text],

It does say SELECT.

Did you mean in VBA? I changed that to select but I must have to change something else because it still doesn't work.

[June7]

The posted db is running an UPDATE sql in the QtyBut click event procedure, not filtering the listbox.