Working in Access 2010, I have a MAIN form that has a subform in a datasheet view.
The Main form allows the user to select a group of products by various categories and subcategories. There are 5 list boxes. When the user selects a category from listbox 1, list box 2 contains a subcategory of the item(s) selected in listbox1. same for List box 3, 4, 5
As the user selects these items, the subform, in datasheet view brings up a listing of thos items within the specific categories selected. Works really cool.
The subform works from a total query as it's control source and is filtered depending on the selection(s) in the Main form. I have another form (DETAIL) which will bring up many more details given a product ID pased to it in DETAIL open args.
What I would like to do is have the ability to double click on the row or an item in the subform and open the DETAIL form. I've looked around and cant find anything that works. I cant seem to capture the subform control DoublClick event or even the Doubleclick event of the subform itself.
Anyone have an idea?