Missing

[Linger1974]

Hi all,

I'm using Access 2003 to work on an Access 2000
database. I've got a form linked to a table, both were
created at the same time. Since the creation though,
I've gone in and added 3 columns to the table, and now
when I try to link to them with 3 new fields in the form,
I'm getting #Name? in the text boxes when running the
form.

When I right click on the form field in design view, and
go into the properties, and look under the control source
dropdown, the field name is not listed. However, when I
use the browse button beside it, I can browse to the
field. Either way, it still displays #Name? after
browsing to it.

Any ideas?

 

[Dirk Goldgar]

Hi all,

I'm using Access 2003 to work on an Access 2000
database. I've got a form linked to a table, both were
created at the same time. Since the creation though,
I've gone in and added 3 columns to the table, and now
when I try to link to them with 3 new fields in the form,
I'm getting #Name? in the text boxes when running the
form.

When I right click on the form field in design view, and
go into the properties, and look under the control source
dropdown, the field name is not listed. However, when I
use the browse button beside it, I can browse to the
field. Either way, it still displays #Name? after
browsing to it.

Any ideas?

Check the form's RecordSource property. It may be set to a SQL
statement that doesn't select all the fields from the table. If so,
just edit that statement to include the fields you added. You can do
this visually by clicking the builder button ("...") that will appear at
the end of the RecordSource property line if you click on that line.