A
Aya via AccessMonster.com
Hi. I've created a database which allows users to seea the security documents
and print them. Also I've made a section for only authorized users can edit
and create new security documents. For creating a new document it's working
properly. But the edit form I've created to make changes isn't working.
The form Edit is a form/subform.
The main form is data obtained from the "Security" query using only the
"Title" field. The "Title" field is a list box showing all the titles of the
security tasks.
The subform contains data obtained from the "Security Documents" table with
fields as "Title", "Department", "Date", "Analyzed by", "Procedures", "Risks",
and "Secure Action".
I linked the "Title" field from the Security query with the "Title" field of
the Security Documents table.
The form Edit works like this:
(1) On the main form, people click on the list box from "Title" field.
(2) When they click on the title name they're looking, the subform
automatically shows the data from that title name. The "Title" field from the
subform isn't visible to prevent users edit the name of the task.
(3) When beginning to edit, the following error appears:
"The changes you requested to the table were not successful because they
would create duplicates values in the index, primary key or relationship.
Change the data in the field that contain duplicate data, remove the index,
or redefine the index to permit duplicates entries and try again."
I've used the no duplicates entry to the "Title" field of the Security
Documents because I don't want duplicates of the title names.
If anyone here has an comment or idea on how can I create an edit form. Also
I would like to know how to create an search form so I can remove the
form/subform function.
Help pleaaaaseee!!!! Thanx.
and print them. Also I've made a section for only authorized users can edit
and create new security documents. For creating a new document it's working
properly. But the edit form I've created to make changes isn't working.
The form Edit is a form/subform.
The main form is data obtained from the "Security" query using only the
"Title" field. The "Title" field is a list box showing all the titles of the
security tasks.
The subform contains data obtained from the "Security Documents" table with
fields as "Title", "Department", "Date", "Analyzed by", "Procedures", "Risks",
and "Secure Action".
I linked the "Title" field from the Security query with the "Title" field of
the Security Documents table.
The form Edit works like this:
(1) On the main form, people click on the list box from "Title" field.
(2) When they click on the title name they're looking, the subform
automatically shows the data from that title name. The "Title" field from the
subform isn't visible to prevent users edit the name of the task.
(3) When beginning to edit, the following error appears:
"The changes you requested to the table were not successful because they
would create duplicates values in the index, primary key or relationship.
Change the data in the field that contain duplicate data, remove the index,
or redefine the index to permit duplicates entries and try again."
I've used the no duplicates entry to the "Title" field of the Security
Documents because I don't want duplicates of the title names.
If anyone here has an comment or idea on how can I create an edit form. Also
I would like to know how to create an search form so I can remove the
form/subform function.
Help pleaaaaseee!!!! Thanx.