Software

Your designer probably did the correct thing and attached your "Form" where the invisible "Field" shows up as #Name?.

Check the Form's Record Source Property to insure the Fields container is pointing to the proper data source (Table or Query based on the table). and check the Fiels'd Row source property to verify you're looking in the coerrect table column.

In either case your proplem is likely a simple property setting.

#Name? appears in a control.

#Name? may appear in a control for a number of reasons. To correct the problem, do the following:

? Make sure that the field specified in the control's ControlSource property hasn't been removed from the underlyingtable, query, or SQL statement.

? Check the spelling of the field name in the control's ControlSource property.

? If you specified an expression in the control's ControlSource property, make sure that there is an equal sign preceding the expression.

? Make sure that there are brackets around references in expressions to control or field names that include spaces. For example, to subtract a Shipped Date field from a Required Data field, enter the following expression: =[Required Date]-[Shipped Date].

Good luck,

Mark

You need to refresh the data source.

Go to properties for the form. If the data source is directly to a table. . . Select a different source go the all tab. Go back to the data tab and reselect the correct data source.

If the data is from aquery built at the form. . .Click on the three dots next to the data source. THis will open the query (that you cannot see from the query tab). Add the new field to the query. Close and save and return to the form.

Chances are answer number is the most likely culprit.

This question was closed by the author