Calculated field won't work...

  • Thread starter Thread starter IHateComputers
  • Start date Start date
I

IHateComputers

I created a form from the parent table that only includes the names of sales
representatives. I had to create a subform to show their sales for each year.

Now I have to create a calculated field to account for a 5% comission rate
over their current rate, but I can only use the form field, not the sub field.

Everytime I put in an equation, I always get a name? or error message.

Any help would be great.
 
I created a form from the parent table that only includes the names of sales
representatives. I had to create a subform to show their sales for each year.

Now I have to create a calculated field to account for a 5% comission rate
over their current rate, but I can only use the form field, not the sub field.

Everytime I put in an equation, I always get a name? or error message.

Any help would be great.
Click to expand...

Some indication of the structure of your tables, the recordsources of your
forms, the expression you've tried and the error message would be useful. You
can see your screen... we cannot!
 
I created a form from the parent table that only includes the names of sales
representatives. I had to create a subform to show their sales for each year.

Now I have to create a calculated field to account for a 5% comission rate
over their current rate, but I can only use the form field, not the sub field.

Everytime I put in an equation, I always get a name? or error message.

Any help would be great.
Click to expand...

Assuming your subform name is "frmSubform" and field name on subform
is "txtField", reference this field into calculation as:

=frmSubform.Form!txtField

If you want to access this field out of form, use syntax like this:

=Forms!frmMainForm.Form!frmSubform.Form!txtField

Regards,
Branislav Mihaljev, Microsoft Access MVP
 
Here are some Microsoft Knowledge Base (KB) articles that you may find helpful:

(ACC2000:) Troubleshooting Tips for Error Values
http://support.microsoft.com/kb/209132

(ACC2002:) "#ERROR" Message When You Reference Subreport Controls
http://support.microsoft.com/kb/288251

(ACC2000:) You Cannot Sum Calculated Controls in Forms or Reports
http://support.microsoft.com/kb/207763

Disregard the references in the titles to a specific version of Access
(ACC2000 and ACC2002). These articles apply equally well to other versions of
Access.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Back
Top