text box on Access subform will not allow data entry? Fix?

[amarillort]

I have a subform located under a tab on a form. It will not allow me to
enter any data into the textbox. It is a combo box linked to a table. I
have set bound columns, column widths, and column count correctly. What am I
overlooking?

 

[ruralguy via AccessMonster.com]

I suspect the query the SubForm is based on is not updateable. Does your
data entry attempts just beep?

 

[J. Goddard]

Hi -

What, if any, error messages do you get? Is the "limit to list"
property of the combo box set to "Yes" (it should be "no")

John

 

[amarillort]

I do not get any error message. The "limit to List" is set to 'No" also. I
do not get any beeps either. The forms control source is a table.

 

[J. Goddard]

Are you trying to enter new records into the same table the combo box is
based on? Remember that although a combo box can display several fields
from a table or query, it can only add to or update one field - the one
it is bound to.

Are the property settings on the subform correct, to allow you to add
new records, or to edit existing data?

John

 

[ruralguy via AccessMonster.com]

Can you change any other control on that SubForm?

I do not get any error message. The "limit to List" is set to 'No" also. I
do not get any beeps either. The forms control source is a table.

Hi -

[quoted text clipped - 7 lines]