asked on

Control Can't be edited; It's bound to autonumber field 'ID'

I am getting the error message "Control Can't be edited; It's bound to autonumber field 'ID'" when trying to bring up data through a subform. Expert will need to download my database, pick 'Campbell' as the instructor, and then try to select a student from the dropdown list to replicate error.

Link to database will be in comment below.

dovcamp

ASKER

File can be downloaded here:

https://filedb.experts-exchange.com/incoming/ee-stuff/2988-CaseManagement-New.zip

Jim Horn

An Autonumber field type automatically assigns values when a record is inserted, and users/developers cannot edit the value.

Downloading your file will not be necessary to answer your question.

dovcamp

ASKER

I understand that part, but I need help figuring out how to tie the sub-form to the form properly.

Jim Horn

What are the common keys of your form and subform RecordSource?
(In design view, click on each and do right-click:Properties, data tab, first parameter)

Then, go to the Properties of your subform, and enter those common keys in the Link Child Fiels and Link Master Fields properties.

Then, since an AutoNumber field is not editable, make sure that your ID in both your form and subform is either set to Enabled=No or Visible=No, so it can't be edited.

dovcamp

ASKER

Where do I find the "Link Child Fields" & "Link Master Fields" properties? I don't see them in the main properties of my sub-form

ASKER CERTIFIED SOLUTION

stevbe

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

stevbe

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dovcamp

ASKER

steveb, when I do that I get a message saying "field cannot be updated"

stevbe

and you really should repair/compact befor zipping, it reduced the file size from 1.94 meg to 426K ... much easier on us :-)

stevbe

<steveb, when I do that I get a message saying "field cannot be updated">
yes ... sorry about posting before fully tested ... please incorporate my second post which ... I did test :-)

dovcamp

ASKER

stevebe,

That did it. The confusion was that I had a field in the Contact table called 'StudentID' that was different than the 'StudentID' field in the Student and Classes table. Thanks for straightening me out, and I went ahead and renamed the StudentID field in the Contact table to StudentNumber.

I will be sure to compact and repair the database next time ;)

This one really had me stumped. Your help is greatly appreciated.