2. ASPRunnerPro General questions
  3. Send Info from field to another field
This topic is locked

Send Info from field to another field

 		2/11/2007 1:10:33 AM
ASPRunnerPro General questions
B
 bburden author

I cant remember how select info from a drop down field to make it update another field. Example I have a dropdown box call equipment_maintance, which has 3 rows of informaion, when one of the rows is selected I would like for certain information to dump to another field.
Can you help me please, I know how to do this in Access through lookup tables, but I can't remeber how to do it in ASP
Thanks for any help - hope I have explan what I need.
J
 		Jane 2/13/2007

Brenda,
use Before record updated or Before record added event for your purpose.

Here is a sample code:

Function BeforeEdit(dict, where)

if dict("equipment_maintance")="value1" then

strSQLSave = "INSERT INTO AnotherTable (equipment_maintance) values ("
strSQLSave = strSQLSave & dict("equipment_maintance")
strSQLSave = strSQLSave & ")"

dbConnection.Execute strSQLSave

end if
BeforeEdit = True
End Function
B
 		bburden author 2/13/2007

Brenda,

use Before record updated or Before record added event for your purpose.

Here is a sample code:


Thanks as always Jane.