New Record

  • Thread starter Thread starter Bryan Hughes
  • Start date Start date
B

Bryan Hughes

Hello,

I am not sure how I should do this.

I have a pop up form in a continuous form view, that shows comments users
have entered in the past. I need to set it so the users cannot edit
previously entered comments, but they can add new comments if they need to.

When they enter a new comment before it is saved to the table, I need to add
some data to some hidden fields to complete the record. How should I do
this?

-TFTH
Bryan
 
i had a similar Comments situation one time. i handled it by binding the
Comments field to a locked textbox, so it could be reviewed but not edited
directly. i added an unbound textbox to the form, and new Comments were
entered there. in the form's BeforeUpdate event, i added a procedure to add
the "new" comments to the existing comments, something like

If Not IsNull(Me!txtNewComments) Then
Me!Comments = Me!txtNewComments & vbCrLf _
& vbCrLf & Me!Comments
End If

i also added a date/time stamp to each addition to the Comments field in my
db, but didn't include it in the code example above.

hth
 
Back
Top