Recent content by apostema

  1. A

    Locking a field/button until another has been completed

    Private Sub Form_Current() If IsNull(Me.LName) = 0 Or Len(Me.FName & vbNullString) = 0 Or Len(Me.Rank & vbNullString) = 0 Or Len(Me.Unit & vbNullString) = 0 Or Len(Me.Shift & vbNullString) = 0 Or Len(Me.Reason & vbNullString) = 0 Then Me.Submit.Enabled = False Else Me.Submit.Enabled = True End...
  2. A

    Locking a field/button until another has been completed

    Still no change.... Trying to make it that once a user enters all the info in the red fields (Capture.jpg) the "Submit" button is then Enabled.
  3. A

    Locking a field/button until another has been completed

    I did and I tried that. Nothing the command button stays disabled after you enter the required information. I am at a loss...
  4. A

    Locking a field/button until another has been completed

    This worked great for me too. I used it against a Command Button... The only thing I can't figure out, is how to get the button to "re-enable" once the fields are filled in. Any advise would be much appreciated.... Private Sub Form_Current() If IsNull(Me.LName) & Len(Me.FName) & Len(Me.Rank)...
  5. A

    Locking a field/button until another has been completed

    This worked great for me too. I used it against a Command Button... The only thing I can't figure out, is how to get the button to "re-enable" once the fields are filled in. Any advise would be much appreciated.... Private Sub Form_Current() If IsNull(Me.LName) & Len(Me.FName) &...
Back
Top Bottom