find data in a subform and putting it in a report

[Guest]

What I have is a form with two subForms. First subForm is labeled Test, this
has test name, control name, lot number and in use date. (About 44 data
entries.)
Second subForm is labeled Test Results has Lan-ID, date, load # and test
results. For each Test I could have many results, that I would like to select
by beginning & endding date.
How can I take one test, then chose beginning and endding dates of results
to put in a report? Can I do it from these sub forms?

Diane

 

[John Vinson]

What I have is a form with two subForms. First subForm is labeled Test, this
has test name, control name, lot number and in use date. (About 44 data
entries.)
Second subForm is labeled Test Results has Lan-ID, date, load # and test
results. For each Test I could have many results, that I would like to select
by beginning & endding date.
How can I take one test, then chose beginning and endding dates of results
to put in a report? Can I do it from these sub forms?

Bear in mind - data is NOT stored in Forms. It's stored in Tables. A
Form is ONLY a window, a way to view and interact with the data in a
Form.

Create a Query based on your (joined) Tables, and base your report on
that Query. The Form would not be involved directly in this process.

John W. Vinson[MVP]