How to LinkUp Combobox for Report search.

[cap.zadi]

Hey there,



I have database where i have 10 different kind of tests each of it have own tables, forms and reports. Each Test having own Auto created TestNo along with Testdate. i am looking to have a combobox where i can see the list of all Tests then if i click one of the test so in next combobox all the tests performed under that should appear with date so can select the test to print out or review.


please Advise?

thanks

zee

[hertfordkc]

First of all, you have a combobox that lists 10 tests from which you can select one.
The selection of one type of test will lead to a combobox containing all of the tests of that type and the date they were performed. A selection on this second combobox will bring up the details of a test performed on a particular date.

If this is correct, then the onclick event of the first combobox sets the recordsource/control source for the second box, and the onclick event of the second combo box sets a filter and opens the final report/subform.

Do you envision doing this with modal/popup subforms?

Have you tried something along this line and run into a problem?

[cap.zadi]

Hey, yes this is the case. no did not try so far but out of it some steps i knows but i am facing problem that how to bring all those Tests in one combo box is it will be right to do in this way:


ELECT MsysObjects.Name, Mid([Name],5) AS QueryName
FROM MsysObjects
WHERE (((Left([Name],4))="rpt_"))
ORDER BY MsysObjects.Name;

so we can have all the tests in this combo box then now how to link up the other combo box which should present all the test performed under a main Test?

If i have Test T01 so then how to bring data in 2nd combox related to this Test only?

please advise here.

thanks.

zee

[hertfordkc]

your first combobox with the names of the tests.
In the onclick event of the first combobox, you can determine which test was selected and use it to insert the name into the query string for the second box, which is its recordsource/controlsource.