So, can the value in an unbound calculated control be referenced in another unbound calculated control? Hope I'm not pressing my luck, just curious.

I'm assuming that you're populating the other unbound control with some type of value based off a user event, that being the case, the answer is yes but it will obviously not retain the data.

yes, but I would suggest doing all your calculations in a query, then using that query as the recordsource for your form.

You can find the name of the unbound TextBox by selecting it and looking at the properties box. should read something like 'text' with a number at the end. Just reference that name for your next calculation.

-Trapper

Ahhh, actually no, I'm working with a report that has continuous rows in the detail section. I got some loooong functions as the control source in one control:

=DSum("[TotalSales]","ChoiceLevel","[ChoiceCode]='" & [Fragrance] & "'" & " AND [Category]= 'CANDLES'")


....and the next control to it needs the value generated by the fx above. The only way I can get the Dsum value is to repeat the same line in the next control! It just seems clunky and I'm sure produces alot of overhead that I'd like to avoid. The report is getting slower and slower. Any suggestions?

Yes, I knew that! But for some reason it didn't seem to be working for me earlier; works now though, thanks!

Could you upload a stripped down copy of your database? I think I know what you can do if what you're trying to do is what I'm thinking. I'll just throw the code into your database instead of C&Ping it in here and trying to explain where to place it.

I started to put up an example but got it fixed! Thx anyways!