About drop down list

[mk2lee1]

Hi, I have this form named school.
On the heading I have drop down list that lists all the name of the schools in the table school. And within the form school is the sub form name presentation.

When I changed the drop down list, all the values of the school form and presentation changes according to school id.

But I want to set the values of certain fields to be drop down list also. For instance, presentationID, in form form presentation (which is currently text box) to be a drop down list that list all the list of presentation id since 1 school can have more than 1 presentation ID. And also, I would like to select the drop down list so that when I click all the datas to be changed according to it.

Can somebody help me on this issue please...

 

[Rolliee]

Cannot visualize your prob. If you wish to send me a ZIPPED mdb and describe the problem, I will see what I can do. The short clear questions get answered first.


rollie@bwsys.net