Basing forms records on another forms records but not recordsource

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top