'get value' from Drop List?

Chris,
you need something like this:

Function BeforeEdit(dict, where)

str = "select * from TableName where " & where

Set rsTemp = server.CreateObject("ADODB.Recordset")

rsTemp.open str, dbConnection
if dict("TEST_PASS_FAIL")<>rsTemp("TEST_PASS_FAIL") then

dict("timestamp")=Now()

end if
BeforeEdit = True
End Function

where TableName is your actual table name, timestamp is your actual field name where timestamp is stored.

Chris,

you need something like this:
where TableName is your actual table name, timestamp is your actual field name where timestamp is stored.

Hi Jane
Thanks for your reply.
My original code is in fact exactly as you've suggested to me but I've learnt/am experiencing that the drop list does NOT assign the selected value to dict("TEST_PASS_FAIL") the first time a value is set. Eg.: when the DB record has TEST_PASS_FAIL value = Null.
I've been displaying dict("TEST_PASS_FAIL") values in debug messages throughout the code to ensure my assumption is correct and hence note the behaviour of this 1st selection.
Any suggestions why this might be happening?
Chris

Chris,
try to use following code:

Function BeforeEdit(dict, where)

str = "select * from TableName where " & where

Set rsTemp = server.CreateObject("ADODB.Recordset")

rsTemp.open str, dbConnection
if dict("TEST_PASS_FAIL")<>rsTemp("TEST_PASS_FAIL") or isnull(rsTemp("TEST_PASS_FAIL")) then

dict("timestamp")=Now()

end if
BeforeEdit = True
End Function