Using form to display result in a drop down box

[Zholt]

Hi, How would i be able to search for XX using a form and then display the results in a drop down box on another form?

 

[wiklendt]

sounds like you want "cascading combos" - there are heaps of examples on this forum. now that you have the keywords, happy hunting!

 

[Zholt]

Thanks i think that is what i am looking for,

Could you please tell me if Csc Combos would be able to allow multiple boxes change the results of one box?

To make my self clearer i will give an example

1st box where you can choose a continent - this would show all the towns in a continent in a dropdown box(D)

2nd box where you can chose a country - this would then show only the towns in the selected country in the dropdown box(D)

3rd box where you can chose a county - this would then show only the towns in the selected county in same dropdown box(D)

 

[DCrake]

That's exactly what cascading comboboxes are designed to do

 

[Zholt]

Would it be easier to run a query based on the data the user enters in a form.

Eg. The user enters their required date/time and then only the date/time they selected will show up in a drop down menu on another form.

If the above is true could you please tell me how i could do this

 

[DCrake]

Here is a Link on how to use public variables that remain intact during the database session.

David