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:
Expand|Select|Wrap|Line Numbers
- 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!