is there such a thing as a dlookup function for use in an asp page 1

[kiwieur]

Hi,

If i wanted to populate other forms fields from a combobox in an ms access database form I would use the dlookup function.

is there something similar that can be used in asp

I have one listbox that contains approx. 30 records

these records are made up of 3 fields that contain the following

code no
type
description

what i would like to do is select a code number from a dropdown list and then populate 2 text fields with the corresponding type and description.

these are examples records
[tt]
21 CN obsolete
14 CR to clear
[/tt]

can anyone point me in the right direction if this is possible please

Regards

Paul

 

[vicvirk]

is this for Classic ASP or ASP.NET?

.NET FORUM:

http://tek-tips.com/threadminder.cfm?pid=855

--------
GOOGLE is a great resource to find answers to questions like "how do i..."

If you don't know exaclty what you want to do or what to search on, try Google Suggest:

http://www.google.com/webhp?complete=1&hl=en

--------
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javasc

 

[kiwieur]

Hi vicvirk,

this would be classic ASP

Regards

Paul

 

[ggriffit]

If you have a look at how

http://www.greggriffiths.org/webdev/clientside/javascript/linkeddropdowns/

works, your should be able to amend it slightly to achieve what you need.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[kiwieur]

Greg,

Thank you for the link, I will have a good look later and see if i can modify the code to provide me with a solution

Regards

Paul