I have a sub form which contains amongst other things 4 textboxes and a disabled button.
My goal is that when all 4 text boxes are filled, the button enables, and if one text box is empty, it immediately disables. My method for doing this was as follows:
This code disables the button immediately when the text box is empty (when it has the focus, the text property would be "" and the value property wouldn't be updated yet) and enables it the second the text box has some text again.
Now, this works perfectly when I have the form open separately.
However, when I try editing the text boxes once I'm using the form as a sub form, runtime error 2185 appears.
I am forced to believe this is a bug of access, but if you can force me to believe otherwise, please do!
My goal is that when all 4 text boxes are filled, the button enables, and if one text box is empty, it immediately disables. My method for doing this was as follows:
Code:
Private Sub c1_Change()
cmdNew.Enabled = Not (IsNull(c2.Value) Or IsNull(c3.Value) Or IsNull(c4.Value) Or c1.Text = "")
End Sub
<same for the other text boxes>
Now, this works perfectly when I have the form open separately.
However, when I try editing the text boxes once I'm using the form as a sub form, runtime error 2185 appears.
I am forced to believe this is a bug of access, but if you can force me to believe otherwise, please do!
Comment