Hi guys,
Googled everywhere for this...
When you've got a form open in pivot table view and you click on different areas of the view, is it possible to grab any data from this view e.g. employeeID, customerID to pass to other subroutines??
If this were possible, I could open a new form by clicking/double-clicking on the pivot view...(Msgbox "HelloWorld" works by double clicking the pivot view but that doesn't help me much LOL) and use e.g. employeeID to filter another form...
Any ideas are welcomed
dazza61
Googled everywhere for this...
When you've got a form open in pivot table view and you click on different areas of the view, is it possible to grab any data from this view e.g. employeeID, customerID to pass to other subroutines??
If this were possible, I could open a new form by clicking/double-clicking on the pivot view...(Msgbox "HelloWorld" works by double clicking the pivot view but that doesn't help me much LOL) and use e.g. employeeID to filter another form...
Any ideas are welcomed
dazza61