Calculation on Form

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

Guest

I am building a Life Insurance form and I have tables that consist of
Employees, Basic Life Insurance Rates, Supplemental Life Insurance Rates,
Dependate spouse and child rates and AD&D rates. Now the rate tables are
according to age, and the employee tables has an age field in it and the
insurance amount. My question is how can get the calculation on the form to
multiply the correct insurance rate to the amount and divide it by 1000.
When I do that, I get an error of "#Name?".

HELP!
 
It sounds like your form's controls have the same name as the fields in the
recordset. It's the default way Access adds controls when you use the form
wizards or drag fields into your form. Access can't decide if you are
trying to use the control or the field, so displays #Name? instead. Try
renaming your controls. I usually put "txt" in front of textbox names,
"cbo" in front of combo box names, etc.
 
Now I get an "#Error" Message

Mark M said:
It sounds like your form's controls have the same name as the fields in the
recordset. It's the default way Access adds controls when you use the form
wizards or drag fields into your form. Access can't decide if you are
trying to use the control or the field, so displays #Name? instead. Try
renaming your controls. I usually put "txt" in front of textbox names,
"cbo" in front of combo box names, etc.
Click to expand...
 
Mark,

Just to clarify... a problem with this only ever arises if you have an
unbound control which is named the same as a field in the form's record
source, and the control source of the control refers to that field.
Having a bound control named the same as the field it is bound to, which
is what you are talking about, will not cause a problem.
 
HRMan,

Can you please post back with some specific details, with examples, and
the exact expression you are using which produces the #Error.
 
Back
Top