Stop a user from editing info in a text box of form already submit

R

rosebud

I have a form with a text box (Due Date) that I want the user to be able to
enter a date. I want the user to be able to return to this record and edit
all other fields but not this one. I know you can allow input but no editing
to a form but is it possible to do the same with just one part of the form?
I am new to Access and hope that I am making sense.
 
E

Eric Blitzer

in the before update event of that contol\
if isnull(me.controlname) then
allowedits = true
else me.allowedits = false
end if
 
R

rosebud

I have a form with a text box for the user to enter a due date. Once the
user enters a date and saves the form for the first time, I want to lock that
text box to prevent the user from editing it. I want the user to having
editing rights to all other text boxes on the form. I am new to Access. I
hope I have made sense.
 
M

missinglinq via AccessMonster.com

Please do not double post on the forum! It potentially wastes the time of the
very people you're asking for help! The person responding on one post has no
way of knowing what's been suggested to you on the other post, and whether or
not the suggestion helped!

If, after a reasonable time, you have not received help, you may move yur
original post back up to the head of the queue, where it's likely to receive
more attention, by simply posting a reply with the message "Bump"

http://www.accessmonster.com/Uwe/Forum.aspx/access-forms/46914/Locking-a-Required-Field


The answers the same as it was two days ago at the above posting!

Private Sub Form_Current()
If Not IsNull(Me.DueDate) Then
DueDate.Locked = True
Else
DueDate.Locked = False
End If
End Sub

This goes in the code module behind your form. Anytime you receive code
that's in the style

Private Sub SomeControlNameForm_SomeEventName()

this is a subroutine that goes in the code module that's underlies your form.

And why have you changed your username from JudyB to Rosebud? Please pick one
and stay with it. I knew that I had already answered your question and spent
a great deal of time looking for it because I assumed you posted it under
Rosebud.
 
J

JudyB

I apologize for the trouble that I put you through. I began this request at
home, got pulled away from my computer immediately after posting the question
and then tryed to finish at work two days later. I was really not sure how
the process worked in regards to the username and was not even sure that I
was successful in posting my problem. I thank you very much for your help
and again am truly sorry for the trouble. Your help solved my problem.
Thanks again, I'll try to do better next time.
 
Top