I am currently upgrading a problem report I did a little while back and my boss asked if I could:
- Auto Complete "Completion Date" field with today's date
- Grey out a select amount of fields for an ECR
- Lock feedback field when form has been signed off
I have been able to complete the second bulletpoint from the list but I am having trouble writing code for both other bullet points.
Problem 1: Auto Complete "Completion Date" field
I have three 3 fields at the bottom of my form which are linked to a lookup field. These fields return names to the boxes.
What I am trying to do is set up an if statement that will say:
Expand|Select|Wrap|Line Numbers
- If Me.QCSignOff.Value > 0 Then
- If Me.ManuSignOff.Value > 0 Then
- If Me.EngSignOff.Value > 0 Then
- Me.CompletionDate.Value = (Today's Date)
- Else
- Me.CompletionDate.Value = ""
- End If
- End If
- End If
Problem 3: Lock Feedback field when form has been Signed Off
This problem is directly linked with the problem above, in the fact that I want the Feedback field to disable when QCSignOff, ManuSignOff and EngSignOff have a value entered into their respective fields.
I left this out of the first problem because I want to deal with one of them at a time.
Thanks in advance for the Help...
(Sorry for messiness)
/Sandy