If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Inputing and Editing Forms
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? When I use only one table to make the form I can edit and input in the form. I have a report table with the ReportID as the primary key. The subject tables feed off the report table with Report ID as foreign keys. |
#2
|
|||
|
|||
Argovian,
I don't see any field linking the two tables. So you may have a recordset that is not updateable. Often down in the status bar it will say just that. Geof. -----Original Message----- 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? When I use only one table to make the form I can edit and input in the form. I have a report table with the ReportID as the primary key. The subject tables feed off the report table with Report ID as foreign keys. . |
Thread Tools | |
Display Modes | |
|
|