Hi there
I'm pretty new to VBA, and I'm trying to wade my way through some complicated stuff (to me it is) to try and get a form to do what I want.
I have created a Quality Database to record evaluations of phone calls (for a call centre). To enter each evaluation, I have a form with 19 essential fields (and 4 subforms that calculate the score on the fly). For reasons of compliance I need to make sure that all fields are filled in with either a PASS or True/False response before either the form is closed or a new record is added.
I've searched through these forums and tried some of the suggestions
ie:
If IsNull(Me.FIELD01) or IsNull(Me.FIELD02) and IsNull(Me.FIELD03) then
Me.NEW_RECORD.Enabled = False
Else
Me.NEW_RECORD.Enabled = True
End If
I have this on the "On_Click" option of the "add new record" button that I have on the form.
The issue I have is that 1. Yes, it disables the button, but filling in the fields so that they are all filled in does not re-acitvate the button (ie it stays disabled).
I tried variations using msg boxes etc, and removing the focus from the button (seems you can't disable the button if clicking it puts it in focus).... But I've had no luck
can anyone help me?
thanks
I'm pretty new to VBA, and I'm trying to wade my way through some complicated stuff (to me it is) to try and get a form to do what I want.
I have created a Quality Database to record evaluations of phone calls (for a call centre). To enter each evaluation, I have a form with 19 essential fields (and 4 subforms that calculate the score on the fly). For reasons of compliance I need to make sure that all fields are filled in with either a PASS or True/False response before either the form is closed or a new record is added.
I've searched through these forums and tried some of the suggestions
ie:
If IsNull(Me.FIELD01) or IsNull(Me.FIELD02) and IsNull(Me.FIELD03) then
Me.NEW_RECORD.Enabled = False
Else
Me.NEW_RECORD.Enabled = True
End If
I have this on the "On_Click" option of the "add new record" button that I have on the form.
The issue I have is that 1. Yes, it disables the button, but filling in the fields so that they are all filled in does not re-acitvate the button (ie it stays disabled).
I tried variations using msg boxes etc, and removing the focus from the button (seems you can't disable the button if clicking it puts it in focus).... But I've had no luck
can anyone help me?
thanks