What event is triggered when I click on a base form? (solved)
I would like to use a macro to auto-filter a base form when I click the mouse in the form. eg click on 'X' in column 'code' and the form will auto-filter to select all records with 'X' in 'Code'. This makes it possible for less skilled operators to work the form. My question is whether an event is triggered when I click on the form and if so what event? Without that, I don't think it can be done.
Edit: I have realised that there is an event associated with the grid, while I was looking for a column event. Can the grid event track down the column and row?