Hi all, i'm getting a headache trying to apply a filter to a datasheet subform in Access.
I have a main form called "Angola PO Errors Report" which holds my buttons for fetching the data etc. and a secondary form called "Ang_PO_errors" which gets its dataset from the main table (main table is also called Ang_PO_errors)
Now i'm trying to stick a button on the main form for filtering results in the datasheet subform, i've tried using a filter query that i've temporarily called "test filter query" but i can't seem to find out how to apply it to the subform via a command button on the main form, i'm an utter n00b to VB so if its a VB solution i may need some further help :/
Thanks in advance
______________________________________________
--If something's worth doing, its worth doing right - HST RIP--
I have a main form called "Angola PO Errors Report" which holds my buttons for fetching the data etc. and a secondary form called "Ang_PO_errors" which gets its dataset from the main table (main table is also called Ang_PO_errors)
Now i'm trying to stick a button on the main form for filtering results in the datasheet subform, i've tried using a filter query that i've temporarily called "test filter query" but i can't seem to find out how to apply it to the subform via a command button on the main form, i'm an utter n00b to VB so if its a VB solution i may need some further help :/
Thanks in advance
______________________________________________
--If something's worth doing, its worth doing right - HST RIP--