Can't assign value subform error

[Tam7877]

I am relearning Access again and am having an issue. I have a main form with a subform. On the subform I have a drop down/Combo item listing different types of equipment. When I go to select one of the listed options, I get this error message:

You can't assign a value to this object
*The object may be a control on a read- only from
*the object may be on a form that is open in Design View
*The value may be too large for the field

Now I don't know a thing about code yet, so please help me out. I do have drop boxes on other forms, but not in subforms. Would this have something to do with relationships?

Thank you

 

[Uncle Gizmo]

could you post the row source for the combo box.

 

[Tam7877]

SELECT [Equipment type].[Equipment Type] FROM [Equipment type];

Does that help?

 

[Uncle Gizmo]

And this field,[Equipment Type] is it text or number, if its text how many characters, and the field the combo box is bound to, what is that? Is it text or number ? And how many characters

 

[Tam7877]

it is a text and the length is the standard 255 (though I don't actually have that much).

 

[Uncle Gizmo]

and the field the combo box is bound to, what is that? Is it text or number ? And how many characters

 

[Tam7877]

sorry. stupid question, where do I find that?

I do appreciate the help

 

[Uncle Gizmo]

Is your subform based on an actual form or is it linked directly to the table?

 

[Uncle Gizmo]

Let's put it a different way round, do you have a form which you display as a sub form on your main form.

 

[Tam7877]

I created a table and then created the subform. That subform was then placed on the main form.

 

[Uncle Gizmo]

>>> I created a table and then created the subform <<<

This subform, I presume the combo box in question is on this form, which field is the combo box linked to? And is the field text, number, if text how many characters?

 

[Tam7877]

It is linked to the field name "Equipment Type". It is a text and it is 15 characters long

 

[Uncle Gizmo]

I believe you need to make both text fields the same length, see if this cures the problem.