Record read only by user (1 Viewer)

[rothjm]

I have created a help desk database. Access 2000 front end and SQL 2000 backend. It has been suggested to me to make the memo field read-only to everyone except the author of the text. I do record the username when the entry is made. Anyone have a suggestion on how to do that? I want the field on the form greyed (read-only) to everyone except the person who wrote it. The original author should be the only one that can change what he wrote. All I care about is on the form...not actual record (on sql).

TIA - Jeff

 

[fpendino]

See if this will work. It is kinda vague, but let me know if you have any more questions.

Enter this into the On Load or On Open of the Form:

If txtUserWhoEntered = CurrentUser then
Memo.enabled = true
else
memo.enabled = False
end if

 

[WayneRyan]

Jeff,

You might also consider not letting them access the "real" memo
field, make it invisible and locked. Put an "unbound" memo field
on your form (no control source), allow them to make their entry
there, and on the AfterUpdate of the "unbound" one you can:

Me.RealMemo = Me.RealMemo & vbCrLf & Me.FakeMemo

Wayne

 

[rothjm]

Thanks - that is along the lines I was thinking.