I have a database (Access) with 6 tables. I created a form for each table. I created an Apex True DBGrid for the database using the first table for display. How do I open my form by clicking on the highlighted record in the Grid and also by using a command button. When the Grid is opened I can use the mouse or arrows keys to highlight each record. I want to be able to select the highlighted record and bring up the form for that particular record.
All you need to do is to put code in both the Grid_DblClick and the CommandButton_Click events. You should be able to look at the selected row in the grid. I’m not sure of the correct properties with Apex’s grid. You could probably make a subroutine to do the form display, and then call that subroutine from both places I mentioned.