Hello,
Is it possible to get the field values of a record by scripting on the onRecordOpen() function?

something like this?? Actually this code does not work, it is only to get you an idea of what I'm trying to do :

function onRecordOpen()
{

Application.Message(Field("DT").Value)

}

thank you
JP

Hi

Yes, you can do that. Try using

Application.Message(Form.boxes("name1").content);

where name1 is the name you have set for that box

Norma

Hi Norma,
I don't want to use boxes, I just want to retrieve the database value directly by scripting.
thank you

Jean Pierre

I see!

Then you will have to do some more complex scripting: use the Recordset and open each record in turn to get the field values!

Norma