In need of great help

Report · May 14, 2006

Hi all,

I know that you get this a lot, but I really need help on this one. here it goes..

Please someone tell me how to display a recordset field on a texbox dynamically when a list/menu onchange event is activated.
I have created a list box and its being populated dynamically from a MSAccess database. What I want to do is to display a data on a texbox when I select a record from the listbox.

For example:

I have a database(dbEmployee) having one table (tblEmp) with two fields:
1)Emp ID
2)EmpName

The "EmpID" field is populated on the listbox on my ASP page. Now all I need to know is how to display the "EmpName" field on the textbox, and that the data that will be displayed on the textbox is within the recordset of the data that I selected from the listbox.

A lot is tellin me that I should use javascript, and they are showing me a tons of codes. You know that being a newbie on ASP coding is really hard for me to read all those codes. I hope that you understand what I'm trying to ask. I will be surely grateful for any help on this. Thank you very much.

Report · May 15, 2006

"deej77" <webforumsuser@macromedia.com> wrote in message
news:e472kq$jaa$1@forums.macromedia.com...

> A lot is tellin me that I should use javascript, and they are showing me a
> tons of codes. You know that being a newbie on ASP coding is really hard
> for me
> to read all those codes. I hope that you understand what I'm trying to
> ask. I
> will be surely grateful for any help on this. Thank you very much.
>

They are correct. It may be hard now, but it's all you can do. There is no
point-n-click cookie cutter, although copying and pasting a cookie-cutter
javascript is basically the same thing.

Just take a deep breath and plunge in. You'll be glad later.

Report · May 15, 2006

thanks lionstone! but if you could send me ASP samples that i could study or tutorials site that have lessons that are exactly the same with what i'm asking, that would be great. I searched the net and found a lot of tutorials, but all of it doesn't come close to what i'm looking. Please please. thanks again and have a great day.

Report · May 16, 2006

In your case, it might be very simple. You say the empID is in the list
box, so I assume the EmpID is the value of the option and the employee name
is the text of the option. In that case, you'd add this to your list box's
opening <select> tag:
onChange =
"document.form1.yourTextField.value=this.options[this.selectedIndex].text"

"deej77" <webforumsuser@macromedia.com> wrote in message
news:e4bspq$j3f$1@forums.macromedia.com...
> thanks lionstone! but if you could send me ASP samples that i could study
> or
> tutorials site that have lessons that are exactly the same with what i'm
> asking, that would be great. I searched the net and found a lot of
> tutorials,
> but all of it doesn't come close to what i'm looking. Please please.
> thanks
> again and have a great day.

>