J
JoMcGuire
I have master form frmStudy
on frmStudy, I have objsubform that I populate based on user selection
sfrmBatchHeaders lists one line of header information for all records
with Parent.StudyID
There's a button on each line to view details.
When that button is clicked, I want to call sfrmBatchDetails to
populate the objsubfrom.
Forms.frmStudy.PopulateSubform "sfrmBatchDetails", "Batch Details",
"[StudiesID] = " & Me.StudyID
the code above is successfully pulling the details of all of the Batch
records associated with the parent "Study"
"PopulateSubform" is a module to which I pass 1) objsubform control,
2)title lable and 3)a where clause - it's working so far
The piece I need help with is having the first record shown in the
details be the specific BatchID that the user selects in the Header
subform. ( does that make sense ? ) I don't want to include "AND
[BatchID]" in the where clause because I want all the detail records, I
just want the specific record selected to be the first one shown....
Any ideas ?
on frmStudy, I have objsubform that I populate based on user selection
sfrmBatchHeaders lists one line of header information for all records
with Parent.StudyID
There's a button on each line to view details.
When that button is clicked, I want to call sfrmBatchDetails to
populate the objsubfrom.
Forms.frmStudy.PopulateSubform "sfrmBatchDetails", "Batch Details",
"[StudiesID] = " & Me.StudyID
the code above is successfully pulling the details of all of the Batch
records associated with the parent "Study"
"PopulateSubform" is a module to which I pass 1) objsubform control,
2)title lable and 3)a where clause - it's working so far
The piece I need help with is having the first record shown in the
details be the specific BatchID that the user selects in the Header
subform. ( does that make sense ? ) I don't want to include "AND
[BatchID]" in the where clause because I want all the detail records, I
just want the specific record selected to be the first one shown....
Any ideas ?