S
Susie W
I am using Access 2003.
I open a scroll form based on criteria collected in a search form. The
scroll form can have one or more records displaying (which includes the
RecordID). In that scroll form, I have a button (Edit All Displayed) that
would open a detail form which will enable you to use the navigation buttons
to go through the detail of each record.
I can't use the same filter on the detail form as the scroll form, because
the underlying queries contain different information. (The filter on the
scroll screen won't work in the detail screen.) But they both contain the
RecordID. What I want to do is base the recordsource of the detail form on
the RecordIDs in the scroll form.
Any way other than to build a sub-query which will pull the IDs out of the
scroll form's recordsource/filter?
Thanks in advance!
I open a scroll form based on criteria collected in a search form. The
scroll form can have one or more records displaying (which includes the
RecordID). In that scroll form, I have a button (Edit All Displayed) that
would open a detail form which will enable you to use the navigation buttons
to go through the detail of each record.
I can't use the same filter on the detail form as the scroll form, because
the underlying queries contain different information. (The filter on the
scroll screen won't work in the detail screen.) But they both contain the
RecordID. What I want to do is base the recordsource of the detail form on
the RecordIDs in the scroll form.
Any way other than to build a sub-query which will pull the IDs out of the
scroll form's recordsource/filter?
Thanks in advance!