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

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top