>
>Thanks, I'll hack that in. I had set my mind to using 2 different queries for year to date and last year sales. Appreciate the tip. Also, the textbox for these values are on a page on a form. Place the code in an event for the page?
>
>Matthew

Depends. If within page data wouldn't change than I'd put this into any object's UIEnable - sort of :

lparameters lENable
if lEnable
thisform.UpdateCusSalesInfo(thisform.CustId)
endif

Otherwise where the data changes.
Cetin