Question:
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.
Answer:
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.
