Aug 14 2008, 04:00 PM
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.
Aug 14 2008, 04:04 PM
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.
Aug 14 2008, 04:06 PM
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.
Aug 14 2008, 04:11 PM
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?
Aug 14 2008, 04:17 PM
Yes, I knew that! But for some reason it didn't seem to be working for me earlier; works now though, thanks!
Aug 14 2008, 04:19 PM
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.
Aug 20 2008, 01:16 PM
I started to put up an example but got it fixed! Thx anyways!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here