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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
I suspect the query the SubForm is based on is not updateable. Does your
data entry attempts just beep?
 
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
 
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.
 
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
 
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 -
Click to expand...
[quoted text clipped - 7 lines]
Click to expand...
 
Back
Top