Hello all.
Using Access 2003 (SP1)
First off, I am new to Acess programming (but not new to programming). I have a small database that I have created that currently contains 2 forms. The first contains 2 combo boxes (Schema Name, and Associated Tables) and a subform. Upon selection of a schema from the first combo box, the second combo box is loaded with all tables from the selected schema. The subform displays, in datasheet view, a listing of the tables (and other data). Right now, If I make a selection from the second combo box, the subform is filtered to contain only that entry selected from the combo box. From there, I can click a command button to open a detail form for the selected table.
What I would like to do is allow the user to select a row from the subform and click the command button (or double click the row) and open the detail form. I cannot figure out how to determine which row in the subform has been selected.
I should also add that the subform's recordsource is query based as is the second (table names) combo box. The first combo box is loaded from a reference data table containing a list of all schemas. Table Names are in a child table that has a foreign key (Schema ID) back to the Schema table.
Please help.
Thanks in advance.
Using Access 2003 (SP1)
First off, I am new to Acess programming (but not new to programming). I have a small database that I have created that currently contains 2 forms. The first contains 2 combo boxes (Schema Name, and Associated Tables) and a subform. Upon selection of a schema from the first combo box, the second combo box is loaded with all tables from the selected schema. The subform displays, in datasheet view, a listing of the tables (and other data). Right now, If I make a selection from the second combo box, the subform is filtered to contain only that entry selected from the combo box. From there, I can click a command button to open a detail form for the selected table.
What I would like to do is allow the user to select a row from the subform and click the command button (or double click the row) and open the detail form. I cannot figure out how to determine which row in the subform has been selected.
I should also add that the subform's recordsource is query based as is the second (table names) combo box. The first combo box is loaded from a reference data table containing a list of all schemas. Table Names are in a child table that has a foreign key (Schema ID) back to the Schema table.
Please help.
Thanks in advance.
Last edited:
