Cannot add/delete/modify data in a control

  • Thread starter Thread starter Anthony Law
  • Start date Start date
A

Anthony Law

Note: I'm using Access 2000 sp3

I have created database with several tables. After
setting up the parameters of the tables I next created a
form, which is linked, to my database. I have several
text box and combo box controls on my form. The controls
are bound to a field/table based on the type of data that
needs to be displayed. However when I run the form and
attempt to add new data, I get the following message:

"Control can't be edited; it's bound to unknown
field 'Change_Request_ID'"

I am considering using sub forms but am unsure. Thanks
for any help I get in advance.
 
Hello Anthony,

Somehow you must have ended up with an incorrect ControlSource for that text
box.
If you open the form in design view and display the Properties pane, you can
click on the textbox and the ControlSource will will be displayed. If you
click on the ControlSource box in the Properties pane and it will display a
combobutton. Clicking on the button will show you which table/query fields
are available.

If you designed the form by displaying the Field List, then dragging a field
from the list to the table, you can be sure all the ControlSources are
valid.

BTW, Access has lots of built in help and also many wizards that can
simplify the design for you. Sometimes it is best to use a wizard, then edit
the form or report to what you want.

Ragnar
 
Back
Top