Accessing the Values Returned by a Database Results Region
Posted on 2004-10-20
I have a Database Results Region that is succesfully returning the values I want. Now I need to do VBScript math calculations with them. Are they not directly accessible to VB? When I reference one in VBS by its field-name it says it isn't defined.
FP closes the recordsource after it retrieves the data so I don't think I can access the original recordsource. Do I have to recreate a database connection/recordsource? That would make the Database Results Region a very limited tool.
How do I access the values in the actual Database Results Region cells to assign them to VBScript variables. Since it is not a form I don't know its name to reference them.