Populating Combo Boxes from a Access Database

[jward]

I have 3 Combo boxes on my Page. The first gets populated
from a table in a Access Database when the page is loaded.
The first combo box contains "Manufactures" When a user selects a manufacturer I want the Page to submit to itself and populate the second Combo box with hardware from the "Hardware" table (ex. Servers, Desktops, Printers).When the user selects the hardware from the second combo box it once again submits to itself and Populates the
third combo box with models from the "Model" table.
I want to stay away from frames if at all possible..

Thanks

 

[travmak]

What you're looking for is javascript. I'm not an expert but try this. If it doesn't work check out the javascript forum.

<script language = &quot;javascript&quot;>
function submitthisform(){
document.formname.submit;}
</script>

<select name = &quot;listname&quot; onchange=&quot;submitthisform();&quot;>

 

[Eduu]

vbscript has an equivalent method
document.formname.Submit
so what you do is that you have Three subs, one for each of the combo's eg
Public Sub ComboBox1_OnChange
document.formname.Submit
End Sub

On submission populate the appropriate combos.
Does this help or was your problem how to actually populate the combos?

 

[jward]

EduU,

I will try that, I can Populate the First box on loading the Page the problem comes when I select something from it to populate the second.