"Edit" feature in Issues Database for Access 2003

[Rosebud]

Under Search Issues tab when a individual conducts a search and returns the
choices, there is an "edit" feature that allows the individual to click on
"edit", then they are able to "edit" the entry. What I am trying to do is
change that "edit" to just "open" the entry and view it. The only place the
"edit" field appears is in the Browse Issues Table under forms, and it's a
subform. Could someone please help. Thank you in advance.

 

[Larry Linson]

Under Search Issues tab when a individual conducts a search and returns
the
choices, there is an "edit" feature that allows the individual to click
on
"edit", then they are able to "edit" the entry. What I am trying to do is
change that "edit" to just "open" the entry and view it. The only place
the
"edit" field appears is in the Browse Issues Table under forms, and it's a
subform. Could someone please help. Thank you in advance.

I have not looked at the Issues Database, but there are a couple of places
where you can specify ReadOnly... one is in the DoCmd.OpenForm statement, as
follows:

DoCmd.OpenForm stDocName, , , , acFormReadOnly

That will override the Form's own settings in its Data tab, but those can
also be set as:

Allow Edits -- No
Allow Additions -- No
Allow Deletions -- No
Data Entry -- No

Probably not in your cases, but sometimes it is more useful to control each
of the Controls on the Form, to allow some but not others to be modified.

Larry Linson
Microsoft Access MVP