Access form "comments" not saving into "tblcomments" table

C

caloy

Good day! I've created an Access form to track performance. It has nine
sections with questions and comments at the end of each section. The form, at
first would work in populating the comments table I've created in a backend
database to which the form is linked. However, after 3 or 4 entries, the form
wouldn't save, the comments table not populated but the scores table does. If
I delete some of the comments the form works perfectly. So, I figured the
"comments" is the issue. I've tried everything from creating the comments as
'memo' datatype, to enlarging the form's comments boxes, to engaging the
scroll in 'scroll type'. Please help.

Carlos
 
M

mscertified

You mention 2 tables. What is the records source for this form? If it's a
query, not all records sources are updatable. Look in Access help for more
information.

-Dorian
 
Top