Bound Issue!

[GLEberts]

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

[Stewart Ross]

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

[GLEberts]

hi stewart,
thanks for your reply - with not to much sleep and alot of coffee worked it out.
thanks again for your help.
Gary