#Name? - error message in forms

  • Thread starter Thread starter Bryan
  • Start date Start date
B

Bryan

I am receiving an error message in some of my fields in a
form I have set up in Access 2002. "#Name?" is displayed
in the text box when I'm using the form. There doesn't
seem to be a problem entering the data using the
associated table. The data in question is dates and
numerical values. Some of my date & number fields work
just fine, but not others. All properties associated with
these text boxes seems correct, but obviously I'm missing
something.

I can't find any info in the Access help so I'd appreciate
any insight you might have.

Thanks.
Bryan
 
Hello.

Is this field bound to a formula??

When dragging the field from the fieldlist onto the form,
both Name and ControlSource is set to the name of the
field.

Later you change the ControlSource, for example to:

=-[TotalAmount]

This should return the negative amount, but Access
searches the form control names before looking for table
fields. Since the control is named TotalAmount, you have a
circular reference.

Short version: Never use the control's name in it's own
ControlSource formula.
 
Thanks Ivan,
One of the fields giving me trouble involved a formula but
the others didn't. I eventually solved the problem on the
others by copying & pasting a field that did work, and
jsut renaming it and changing the control source setting.
I think there was a problem with how the control source
was set. I'll have to check tonight on the remaining one
(involving a formula) to make sure that the control's name
hasn't been used in it's own control source formula.

Thks,
Bryan
-----Original Message-----
Hello.

Is this field bound to a formula??

When dragging the field from the fieldlist onto the form,
both Name and ControlSource is set to the name of the
field.

Later you change the ControlSource, for example to:

=-[TotalAmount]

This should return the negative amount, but Access
searches the form control names before looking for table
fields. Since the control is named TotalAmount, you have a
circular reference.

Short version: Never use the control's name in it's own
ControlSource formula.


-----Original Message-----
I am receiving an error message in some of my fields in a
form I have set up in Access 2002. "#Name?" is displayed
in the text box when I'm using the form. There doesn't
seem to be a problem entering the data using the
associated table. The data in question is dates and
numerical values. Some of my date & number fields work
just fine, but not others. All properties associated with
these text boxes seems correct, but obviously I'm missing
something.

I can't find any info in the Access help so I'd appreciate
any insight you might have.

Thanks.
Bryan
.
Click to expand...
.
Click to expand...
 
Back
Top