Editing and inputting in Forms

[Guest]

I have made a form using the form wizard and in-corporated fields from two
tables (Student name etc) and (Subject, Group and Comments). The comment
field uses the Memo Datatype. When I put the form in datasheet view, The add
record button at the bottom is inactive and I am unable to edit the form or
insert any comments into the form. I have also activated the allow edits in
properties. What have I missed out?

 

[John Vinson]

I have made a form using the form wizard and in-corporated fields from two
tables (Student name etc) and (Subject, Group and Comments). The comment
field uses the Memo Datatype. When I put the form in datasheet view, The add
record button at the bottom is inactive and I am unable to edit the form or
insert any comments into the form. I have also activated the allow edits in
properties. What have I missed out?

I suspect that you may want to use a Form (based on the students
table) with a Subform (based on the other table) - and that you may
want to examine your table relationships. What is the Primary Key of
each table? (If it doesn't have one - it's not a table.) How are the
tables related? (If they're not, you can't edit).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps