By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 1,221 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Bound Issue!

P: 51
I almost have a problem solved with the help of someone in here already. I just need yet to "bound" the control to the (EstimateID) or somehow.
I have a unbound value from a text box from another form and having it show up in a report.

What works is - =Forms!fmestimate!txtestimatetotal

The form I am looking up information from is "fmestimate"
Text Box Name is "txtestimatetotal"
Text Box Control is "=CDbl(nz([txtproductlaborcosttotal],0))+CDbl(nz([txtsalescommission],0))

The above gives me the estimate total on the report page but does not keep the total with the "EstimateID" or each record.

I have tried several ME.! scenerios with errors.

Please help this is the last piece of the puzzle before I can get this thing up and running.
Thanks
Gary
Apr 28 '08 #1
Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
Hi Gary. You haven't given enough detail of the tables and queries underlying your report for me to be specific here, but I am certain that instead of trying to lookup a calculated field from another form you should include the calculated field directly in the query on which your report is based. I get the impression that you need to produce an intermediate group total of some kind for your estimates report, and you simply will not be able to do this by looking up a static value from another form.

Open the report's recordsource query, add the relevant table and join it on the appropriate fields (EstimateID and any other key fields that make the row references unique). Include a computed total for your estimate as a new computed field in your query. Your report can then total the computed field for you, grouped in whatever way is appropriate.

If you find this difficult to do please post the relevant SQL for your report along with sufficient detail of the tables you are accessing in your form to allow us to post revised code for you which will do what you need to do.

-Stewart
Apr 28 '08 #2

P: 51
hi stewart,
thanks for your reply - with not to much sleep and alot of coffee worked it out.
thanks again for your help.
Gary
Apr 28 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.