adding calculated field to a form

[Guest]

Thanks for all the help so far.

I have a subform that I need to add a calculated field to. I can bring up
the expression builder but how do I get it to become a field on the form?

When I put the expression together it just sits in the builder and I am not
sure how to get it on the form.

Thanks

 

[Al Campagna]

Dig,
Cut & Paste the built calculation into the ControlSource of your "unbound" subform
field.
ex... = [Price] * [Qty]
Actually the process would be...
Create an unbound text control on the subform.
Place your cursor in the text field of the ControlSource property.
Right click that text field.
Select Build from the pop up menu.
Build your calculation, and say OK.
That calculation will now be entered in the ControlSource...

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."