calculations from a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form with a subform. I need to subtract a feild from the
subform from a feild on the form. Also the data from the fields come from two
seperate tables. 1. Can this be done? 2. If so, how? Thanks.
 
Marc,
Use your own object names...
=Forms!frmMainForm!SomeMainField - Forms!frmMainForm!frmSubForm.Form!SomeSubformField
should do it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
Show Oldest Record First in subForm 5
Use field to update multiple fields 4
create a form with mutiple fields 1
Subform 7
How to always get the top level form reference, when calling from any subform/subform... 0
Need help on how to pass calculated field from a form to another form 0
when binding a control to a field not from a loaded form it cause. 1

Back
Top