# Flash MX Combo Box Component

**URL:** https://forum.kirupa.com/t/flash-mx-combo-box-component/115713
**Category:** Uncategorized
**Created:** [July 11, 2004, 3:59am UTC](https://forum.kirupa.com/t/flash-mx-combo-box-component/115713 "2004-07-11T03:59:06Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![aspnewbee](https://avatars.discourse-cdn.com/v4/letter/a/439d5e/32.png) [@aspnewbee](https://forum.kirupa.com/u/aspnewbee)
#### Post date: [July 11, 2004, 3:59am UTC](https://forum.kirupa.com/t/flash-mx-combo-box-component/115713/1 "2004-07-11T03:59:06Z")

</div>

Hi I’m trying to insert some data into my DB from two Combo Boxes in Flash. I’m not quite sure how to go about it. I have one combo box listed in the actionscript below. Can anyone help me please…  
Thank you all in advance.

Here is my actionscript:

```auto

on (release) {
function getthevalue() { 
passthis = major.getSelectedItem(); 
if(passthis != "")
{
loadVariablesNum ("[http://localhost/test/acadForm.asp](http://localhost/test/acadForm.asp)", "0", "POST"); 
}
else{
_root.messageBox.text = "please select an option";
}
} 
nextFrame();
}

```

Here is the ASP Code:

```auto
 
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
strMajor = Request.Form("major")
strCollege = Request.Form("college")
'Response.Write(strMajor) & "<br>"
'Response.Write(strCollege) & "<br>"
MyPath=Server.MapPath("uginfo.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & MyPath
SQL = "INSERT INTO acad_choices (major, college) VALUES('"&strMajor&"', '"&strCollege&"')"
'Response.Write(SQL)
conn.Execute(SQL)
%>

```
