Not allowing edits

D

Doug_C

Hello,

I have a problem I am trying to solve and would appreciate any help offered.

I have a form with a Command Button "Enter Update Status". When clicked, it
prefills the current date and time in a textbox called "Status". The Status
box is continuous showing all comments my on a particular project. The only
problem is, when a user adds a new comment, they can also edit a previous
comment. Is there a way to view all comments but not be able to edit any
previous comments only add a new one?

I was thinking if I could create a pop up box so when the Enter Update
Status button is clicked a pop up box let you input the comment and have a
button on that saying "Add Comment". Would this be difficult or is there and
easier way.

Thank you for you help in advance!!
 
D

Doug_C

Hi Ofer,

This is a great suggestion and will store this with my other information.
What this does is exactly what I want to happen but only with the one field
and not the whole form. In otherwords, when I implement it, it works great
but it will not let me make a select from the cbo. If this could work the way
it does but let the user make a selection from the cbo, this solves my
problem. Is this a possibility or do I need to go about this differently?

Thank you!
 
O

Ofer

Disabeling the edit won't let you edit the combo, it will lock all the fields
in the form, in that case you have to lock and unlock the fields depends on
the value of the a certain field

If not isnull(Me.field1) then
me.field2.locked=true
me.field3.locked=true
else
me.field2.locked=false
me.field3.locked=false
end if
 
D

Doug_C

Where does this code go? I will try to use it today. I assume I want to make
the Allowedits - "No" and use this code correct? I only want to leave the cbo
"Live" all the time and the comments box live only until the update has been
made. I do want the use to be able to go back to that record to add more
comments if needed but not edit any of the exizting comments that were
entered previously. Will this be what I am going to accomplish with that
piece of code?

Thanks!!
 
Top