>
>
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?
>
>MatthewDepends. 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