#Name? Error on subform

Question

I've created a form with a percentage calculation. The form works perfectly. But, when I put the form on my menu form, the calculated field changes to #Name?. It's not referenced on the menu - the forms don't interact in any way.

What could be causing this?

Thanks!

April

Answer 1

I think you don't need to reference the form. Try:

=[Units]/[Total]

However I'm not sure if you really mean [Units] or if it is [Count].

Answer 2

Yes, when you identified that the controls you want are on frmStatusWin10 in the Forms collection Access will look for them there. But they aren't there anymore. Then are in Forms!frmMenu!frmSTatusWin10.form.Units. That's why the error.

By not qualifying where they are, Access looks on the current form.

Answer 3

I think you don't need to reference the form. Try:

=[Units]/[Total]

However I'm not sure if you really mean [Units] or if it is [Count]. 

That works! And now that I look at it, I can see it.

I had the formula that way before but it kept giving me the wrong numbers.

Thanks!

April

Answer 4

I have a frmStatusWin10 with four fields:

OS

Count

Total

Percent (Calculated field: =[Forms]![frmStatusWin10]![Units]/[Forms]![frmStatusWin10]![Total] )

When the form is opened, it shows everything correctly:

OS                     Units       Percent       Total

Not Win10         39              53%              74

Windows 10       34              46%              74

Windows 7           1              1%               74

I made frmStatusWin10 a subform on my menu form, and it shows:

OS              Units       Percent       Total

Not Win10        39       #Name?       74

Windows 10      34      #Name?       74

Windows 7        1        #Name?       74

Answer 5

In an embedded form, the references are different. What is the Controlsource of the control.