properties error in the field in the form

J

Janis

I just created a form. On the fields there must be an error in the
properties. I can't type in the field and I have the #name? error and the
#error Error. It looks like I connected the fields to the underlying table
correctly so what should I check?



=Employees!Emp_ID
=Employees!FirstName
=[Salary]

thanks,
 
A

Arvin Meyer [MVP]

If the fields are bound to textboxes on the form, you do not need to use a
reference to the underlying table or query.

Emp_ID
FirstName
Salary

should be all you need in the controlname property.
 
J

Janis

I'm trying to bind the field to the table. It doesn't seem to work. I try
binding it to the table and also I tried binding it to the fields listed in
the form. neither one works. What else could I try? It says "control can't
be edited it is bound to an unknown field emp_ID"
thanks,
 
J

Janis

The form wasn't bound to the table, now it is :) thanks,
Arvin Meyer said:
If the fields are bound to textboxes on the form, you do not need to use a
reference to the underlying table or query.

Emp_ID
FirstName
Salary

should be all you need in the controlname property.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Janis said:
I just created a form. On the fields there must be an error in the
properties. I can't type in the field and I have the #name? error and the
#error Error. It looks like I connected the fields to the underlying
table
correctly so what should I check?



=Employees!Emp_ID
=Employees!FirstName
=[Salary]

thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top