Combo box "Control can't be edited"

Hi everyone,

I have a problem relating to a combo box.

I have got a form based on a table called 'Notes', whose primary key is 'NoteID'.

What happens is, the database has numerous cases whicah can each have notes based on it, so the 'Notes' table also has a 'CaseID' field which can then be linked to the 'Cases' table.

When I go to a particular case and want to edit a note just for this case, I click on edit note and it brings up the form.

If there are more than one notes based on this case, for example they were put on different dates, then obviously I only wish to edit one note at a time.

So I have created a combobox based on the 'NoteID' field and I want to be able to choose one of those and then it brings up the details of the note for that particular ID that I can then edit and save the changes.

My problem is whenever I try to click on the combobox to try and choose a note, it comes up saying "Control can't be edited; it's bound to AutoNumber field 'NoteID'" and I am not 100% sure why this is happening. From what I have read, it may be easier to create a query based on the notes table and do something from there.

Any insight is much appreciated.

Thanks.
Gareth.

The ComboBox should not have a ControlSource. Clear the ControlSource and it should work.