Re: Passing dropdown list value to another SELECT statement on same page

[Jack Berberette]

Hi Peter...sorry for the delay. I was out yesterday and just now saw this.

My hopes were to have the choice from the dropdown box populate the WHERE part of the select statement (this is where I put " NOT SURE WHAT TO PUT HERE"). I feel like I'm really close but just don't understand how to get the dropdown selected value to be the WHERE part of that statement.

The idea is that a user would select the desired race from the dropdown list...and immediately display a table with just the values for that selected race.

I hope this helps.