Hi:
I have a combox on my form and if the user changes its value to "Active" or "Pending" a message box pops up that tells the user to make an entry in a subform.
This is the code that I have on the After_Update event of the combobox
If Me.NewRecord = False
If Me.Combo = "Active" or Me.Combo = "Pending" Then
MsgBox "Please make an entry in the Notes field", vbOKOnly
End If
End If
My question is that right now it just tells the user to make an entry in that field. I want to force the user to make an entry. There are 2 fields that the user needs to enter in-Notes and Notes Date-which are on a subform. I have 3 subforms that are on a tab control. I want to set focus on the Notes subform and lock everything else. Only when the user has entered data in these two fields they should be able to click anywhere else.
How can I do this? Sample db is attached.
Thanks,
Ekta
I have a combox on my form and if the user changes its value to "Active" or "Pending" a message box pops up that tells the user to make an entry in a subform.
This is the code that I have on the After_Update event of the combobox
If Me.NewRecord = False
If Me.Combo = "Active" or Me.Combo = "Pending" Then
MsgBox "Please make an entry in the Notes field", vbOKOnly
End If
End If
My question is that right now it just tells the user to make an entry in that field. I want to force the user to make an entry. There are 2 fields that the user needs to enter in-Notes and Notes Date-which are on a subform. I have 3 subforms that are on a tab control. I want to set focus on the Notes subform and lock everything else. Only when the user has entered data in these two fields they should be able to click anywhere else.
How can I do this? Sample db is attached.
Thanks,
Ekta