Want to learn how clicking on a column on a datasheet in the header section can
repopulate the datasheet in the detail section.
header section - datasheet - totals
detail section - datsheet - show actual rows
would like, if click on a column in totals sheet, would repopulate detail datasheet
i sort of have something working like this:
.RecordSource = "qp_050_Discoverer_SortByL
BUT: i have queries using different tables, so if i change a recordsource to use a query
whose fields are not in the datasheet design view, i get a #NAME error.
so i guess, that i have to create another datasheet for the other query's fields
and dynamically change the FORM name in additon to the data source
i am getting errors trying this below:
i am getting an error that: sbf2_Students does not exist, yet it does.....
any help or ideas would be deeply appreciated.
the mdb is posted below....tx, sandra
.SourceObject = "FRM_040_Totals_sub3_NRMP"
.RecordSource = "qp_010d_No PGY1"