Recent content by meanie

OMG, I had that at one point including other Where arguments, but in my experimenting, it didn't work because of problems in the code and I forgot to come back to it. It works! Thank you. :banghead: I'm pasting the working code below for reference: Option Compare Database Option Explicit...

Thanks, sneuberg. So in testing yours, everything works like how I want it to, even when I switch it from a command_click to the 'StockSearch()' function in the after update of the combo box. So again, I'm a noob with coding. I can generally figure it out, but I don't know all the rules...

Thanks for the replies. Progress so far: - using "Form.Filter & CurrentFilter", I get error 3075, snytax error (missing operator) - using "Form.Filter & " And " & CurrentFilter" causes the filter to break - when choosing an item from a combo box, the results in the subform are null - adding...

The msgbox displays whatever filter I applied through the combo box, but does not include the common filter. For example, I chose a fiscal year and a DIR, which applied the filter. Then, in the subform, I right clicked in the name field, and selected a name to further the filter. When pushing...

Hello! first time long time. Anywho, I have a Report section, taken and modified from the Northwind sample. It uses comboboxes and option buttons to apply a filter to a subform, and then pushes the filter to the report. That all works fine. However, in the subform, when you click on a field...