In your code below how is it passing over the item_number? thisform.ItemNo in the click command is the Item number I am passing to the GETPRICE method? But it for the replace command thisform.getprice is returning the value calculated by GetPrice? I assume that (thisform.ItemNo) is passing the item# to the getprice mathod and does not contain the returned value?

I did not intend to return an array, I just need to return a single price xxxx.xx so I could simple say in my method return_price=xxx+yyy etc?

David



--------your code------------------------
* Form.GetPrice 'method'
lparameters tnItemNumber
external array arrPrice
select price from products where ItemId = tnItemNumber into array arrPrice
return iif(_Tally=0,0,arrPrice)

* Commandbutton.click
replace myfield with thisform.GetPrice(thisform.ItemNo)