Form Filter reference problem (1 Viewer)

I have a toggle box on my Main form.[frm_frontapage]
This filters a sub form [frm_qry_CR_DATA]

If I hard text my filter on my toggle box the filter works:



"autoaction = 'to be actioned'"

I want a Combo Box [Combo20] on my main form to do the same filter but to reference what is (afterUpdate) I select in [Comb020]

I cannot seem to filter using the same code e.g.


Thanks chaps !! (and chapesses of course)

Have a look here http://access.mvps.org/access/forms/frm0031.htm - you need to refer to the parent form if you are on the sub form, and your syntax is off - try something like;

Hi Minty
Im not on the sub form.
Combo20 is on the parent form
So I edited your suggestion(removed the parent bit) and voila !!!
works like a treat
Many thanks