Actually, yes the function does have manipulate and calculate data so that's why I didn't include it in the SQL. I turns out though that the whole thing was just a snafu on my part as the reason the record pointer didn't appear to be moving was that in the function, I wasn't referring to the right table. Doh!

Thanks for your response though! -Rick


>>I have a report that pulls data from a temporary cursot that gets built on the fly with a sql statement. The cursor is called tempcur.
>>
>>One of the fields in the detail band of my report has the following express oApp.GetBval(). GetBval is a method of my application object that that returns a numerical value. To do this, in the method I'm doing a seek in another table based on the value in tempcur.cust_id.
>
>If the only purpose for GetBval() is to pull the numeric value from another table according to the value of tempcur.cust_id, and it does not have to manipulate or calculate anything, you can just include the other table field in your SQL SELECT statement using a JOIN or WHERE clause to relate the two tables together.