Dynamic Drop Down Box populated by Access tbl field with text box populated from the same table corresponding field

Posted on 2008-10-29
Last Modified: 2010-05-18
Good day all.

I have a web form I have created. I have a field that requires the user to enter the ACNA (Access Carrier Name Abbreviation - telcom) and then the corresponding Customer name in the next text box.
I have both the ACNA and the corresponding Customer name in an Access Database (EAST_pm) and table (tblMasterACNA).

I would like to create a drop-down list for the ACNA, based on the field ACNA in tblMasterACNA. Once the user selects the ACNA the next text box would be populated automatically with the corresponding Customer Name in the Customer field from the tblMasterACNA.

I am using ASP, SQL and some Javascript on my site.
I have posted my code and has you can see, I am using a FIELDSET, not sure if that will matter.
This form is sent back to another table within the same database.

Thanks for your assist..
<img src="logo_secondary.gif" class="floatTL"><br><br>	
<script Language="JavaScript">
function Blank_TextField_Validator(form)
if (Input.CAC.value.length < 1)
alert("Please enter a value for CAC.");
return (false);
if (Input.CKTID.value.length < 1)
alert("Please enter a value for CKTID.");
return (false);
if (Input.ACNA.value.length < 1)
alert("Please enter a value for ACNA.");
return (false);
if (Input.Ticket Number.value.length < 1)
alert("Please enter a value for Ticket Number.");
form.Ticket Number.focus();
return (false);
return (true);
<style type="text/css">
	width: 1px;
	height: 14px;
	color: white;
	font-size: 12px;
  overflow: hidden;
	background-color: red;
	padding-left: 5px;
<script type="text/JavaScript">
function textCounter(field,counter,maxlimit,linecounter) {
	// text width//
	var fieldWidth =  parseInt(field.offsetWidth);
	var charcnt = field.value.length;        
	// trim the extra text
	if (charcnt > maxlimit) { 
		field.value = field.value.substring(0, maxlimit);
	else { 
	// progress bar percentage
	var percentage = parseInt(100 - (( maxlimit - charcnt) * 100)/maxlimit) ;
	document.getElementById(counter).style.width =  parseInt((fieldWidth*percentage)/100)+"px";
	document.getElementById(counter).innerHTML="Limit: "+percentage+"%"
	// color correction on style from CCFFF -> CC0000
function setcolor(obj,percentage,prop){[prop] = "rgb(80%,"+(100-percentage)+"%,"+(100-percentage)+"%)";
<script type="text/javascript">
function handleEnter (field, event) {
		var keyCode = event.keyCode ? event.keyCode : event.which ? event.which : event.charCode;
		if (keyCode == 13) {
			var i;
			for (i = 0; i < field.form.elements.length; i++)
				if (field == field.form.elements[i])
			i = (i + 1) % field.form.elements.length;
			return false;
		return true;
<link href="" type="text/css" rel="stylesheet" media="all">
<body bgcolor="white" text="black"onLoad="self.focus();document.Input.CAC.focus()" >
<!-- Begin form code --> 
<LEGEND><b><h1>Issue Referral Form</h1></b></LEGEND>
<H3>* All fields are required*</H3>
<form name="Input" method="Post" action="Confirm.asp">
<input type="hidden" name="Region" value="Potomac">
<input type="hidden" name="Date Added" value="<%=Date()%>" />
<tr><td>CAC: </td>
<tr><td><input type="text" name="CAC" size=40 value="" onChange="javascript:this.value=this.value.toUpperCase();"onkeypress="return handleEnter(this, event)"></td></tr>
<tr><td>CKTID: </td></tr>
<tr><td><input type="text" name="CKTID"  size=40 value="" onChange="javascript:this.value=this.value.toUpperCase();"onkeypress="return handleEnter(this, event)"></td></tr>
<tr><td>ACNA: </td></tr>
<tr><td><input type="text" name="ACNA" size=40 value="" onChange="javascript:this.value=this.value.toUpperCase();"onkeypress="return handleEnter(this, event)"></td></tr>
<tr><td>Customer: </td></tr>
<tr><td><input type="text" name="Customer" onkeypress="return handleEnter(this, event)"></td></tr>
<tr><td>Ticket Number: </td></tr>
<tr><td><input type="text" name="Ticket Number" size=40 value="" onChange="javascript:this.value=this.value.toUpperCase();"onkeypress="return handleEnter(this, event)"></td></tr>
<tr><td>Ticket Source: </td></tr>
<tr><td><SELECT NAME="Ticket Source" SIZE="1">
<tr><td>Monitoring Source: </td></tr>
<tr><td><SELECT NAME="Monitoring Source" SIZE="1">
<tr><td>Dispostion Code: </td></tr>
<tr><td><SELECT NAME="Dispostion Code" SIZE="1">
<tr><td>Date Closed: </td>
<tr><td><input type="text" name="Date Closed" </td></tr>
<tr><td>Summary: (limited to 50 Characters)</td></tr>
<tr><td><textarea cols="50" name="Summary"size=40 value="" onChange="javascript:this.value=this.value.toUpperCase();"
></textarea> </td></tr> 
<input type="submit" name="Submit" value="Submit Form" class="flashit" onClick='form_name.button_name.value="Please Wait...";return true'>
<input type="reset" value="Clear Form">
<div id="progressbar1" class="progress"></div>
<!-- End form code -->
<script language="JavaScript1.2">
var flashcolor="red"
var flashinterval=1000 //flash interval in miliseconds (1000=0.5 sec)
var formcollect=document.getElementsByTagName? document.getElementsByTagName("FORM") : document.all? document.all.tags("FORM") : new Array()
var flashcollect=new Array()
for (i=0; i<formcollect.length; i++){
for (e=0; e<formcollect[i].elements.length; e++){
if (formcollect[i].elements[e].className=="flashit")
function flashelements(){
for (f=0; f<flashcollect.length; f++){
if (flashcollect[f].style.color=='')
if (flashcollect.length>0)

Open in new window

Question by:vzdog
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Expert Comment

ID: 22833390
Here's what I use when I run into this requirement.  It's a combination of VBScript and JavaScript and it works very well, in my experience.

Author Comment

ID: 22836910
Not sure if this would wor or I should say not sure if I know how to modify it so it will work. As I said my requirement is that the specific ACNA field is tied to a specific customer name so there would not be a need to have a drop down.


Accepted Solution

saoirse1916 earned 500 total points
ID: 22837683
Ahh, ok -- I was way off.  Check out something like this, it should do the trick.

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Microsoft SQL ADO Conn Issue 6 59
Time comparison asp 1 22
Want an individual results display div 8 49
Prevent certain words from being typed in a form 6 31
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
In an interesting question ( here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question