Adding existing fields in a form

[MsDYJ]

I'm creating a multiple-item form to use as a dashboard that is based on another form. The multiple form is automatically populated with all the controls from the other form, except an unbound text box I inserted to show an actual cost. Is there away I can insert this control into my dashboard? I tried the "add existing fields" option but the text box doesn't show.
Thanks in adv.
Diana

 

[missinglinq]

You're making the common mistake of confusing fields and controls! A table contains fields. A form contains controls, such as textboxes, that display the fields from tables, either directly, with the table being used as the RecordSource for the form, or indirectly, with a query containing the table fields being used as the RecordSource.

An unbound control, such as you have in your first form, is not connected to any field in any table, and as such, doesn't exist beyond the form it was created in, and won't appear in the fields list. You'll have to re-create the unbound control in the new form just like you did in the original form.

 

[MsDYJ]

I did so, but I'm still getting the #Name? error. Any other suggestions? Thanks

 

[Endre]

The error is in your ControlSource formula of the unbound object. Perhaps the formula you are using refers to a control or object that exists(ed) on the old form that you are recreating, but is refered to differently on the new form. Check your cost formula.

 

[missinglinq]

Like the swimming Endre said! It would probably help if you posted the code you're using along with the name of this new form.

 

[MsDYJ]

Here is the code:

=[Forms]![sbfMaterials]![MaterialsSum]+[Forms]![sbfResources]![ResourceSum]

 

[missinglinq]

When controls on forms are referenced like this, all forms involved have to be open, are they?

 

[MsDYJ]

No........