I've broken this question up into 3 parts:
SetScene: I've set up a Form that displays inventory balances for our storage warehouse. The form consists of a subform that is set to be viewed as a datasheet that obviously holds all the Inventory Balance data.
1. I now want to see if it's possible to add a feature where, if a user double-clicks a cell value in the datasheet. The datasheet will then automatically filter itself with the cell value that the user has double-clicked on.
2. Any filtering that is applied by this method, I then want to write back to the query so that a report can be then be generated based on the filtering.
3. A method of undo-ing the applied filters to bring back the full inventory balance (would prefer a command button).
Can anybody help me out with this one??
Thanks in Advance.
Tadynn.
SetScene: I've set up a Form that displays inventory balances for our storage warehouse. The form consists of a subform that is set to be viewed as a datasheet that obviously holds all the Inventory Balance data.
1. I now want to see if it's possible to add a feature where, if a user double-clicks a cell value in the datasheet. The datasheet will then automatically filter itself with the cell value that the user has double-clicked on.
2. Any filtering that is applied by this method, I then want to write back to the query so that a report can be then be generated based on the filtering.
3. A method of undo-ing the applied filters to bring back the full inventory balance (would prefer a command button).
Can anybody help me out with this one??
Thanks in Advance.
Tadynn.
