Access 2000 - "#Name?"

[Todd]

Hello,

When I create a new form in design view, manually draw a
text box, go to the properties of the text box and use the
expression builder in the control source to bind the text
box to a field from an existing table, I get "#Name?" in
my text box when in 'form' view instead of my test data.
However, if I use the wizard to create a form, my test
data appears normal inside the text box when in 'form'
view.

Per the online help file - I have checked the syntax and
it's fine, I've made sure the MSOWCF.dll is present on my
system in the proper windows/system directory for my OS
(Win2K), and I have even re-installed Access but nothing
seems to help.

Thoughts anyone? Thank you,

Todd

 

[vince]

If you creating the field in Forms and that field does not
exist on your table or if the field in your table is a
calculated field, yeah you will get that error. From what
I can understand on Access, calculated fields in Forms do
not update data on tables. You would have to create a
query and base your Form on that query.

Hope this gives you some insight....

 

[Dan Artuso]

Hi,
You can only bind a control to a field that's present in the form's record source.
In which case it will appear in the drop down in the Control Source property.

 

[Mike Painter]

Hello,

When I create a new form in design view, manually draw a
text box, go to the properties of the text box and use the
expression builder in the control source to bind the text
box to a field from an existing table, I get "#Name?" in
my text box when in 'form' view instead of my test data.
However, if I use the wizard to create a form, my test
data appears normal inside the text box when in 'form'
view.

If there is a recordset bound to the form all you have to do is drop the
list down and add the field.
If the form is unbound or you want to use an unbound textbox you can't use
= SomeTable!SomeFieldName.
If for no other reason, the system would not know which row in the recordset
to return.
You will have to use a query or dLookup to get the value you want and
dlookup must rely on some value on the form to get the exact record you
want..