J
|
Jane 10/6/2006 |
Hi, Sub AddOnLoad() str = "select * from TableName where ID=" & GetRequestForm("masterkey") Set rsTemp = server.CreateObject("ADODB.Recordset") rsTemp.open str, dbConnection Session("Project") = rsTemp("Project") Session("Customer") = rsTemp("Customer") End Sub
|
C
|
clig author 10/6/2006 |
Hi, you can do it using events. Proceed to the Events tab, select AddOnLoad event and add your code in it. Here is a sample code: where TableName is your actual table name of master table. Then use Session("Project") and Session("Customer") as default values on the Edit format dialog on the Formatting tab.
|
C
|
clig author 10/6/2006 |
Hi, you can do it using events. Proceed to the Events tab, select AddOnLoad event and add your code in it. Here is a sample code: where TableName is your actual table name of master table. Then use Session("Project") and Session("Customer") as default values on the Edit format dialog on the Formatting tab.
|