So far on a form I'm using I haven'tbeen able to use VBA code successfully.
I'm not sure why this is happening, maybe there is something wrong with my database?
My recent attempt was to get a textbox to appear visible only when "None" was selected on the combobox next to it.
The code for this was:
Private Sub CboOutletSize_AfterUpdate()
Dim strsize As String
Dim bolquantity As Boolean
strsize = Me.CboOutletSize.Value
If strsize = "None" Then
bolquantity = False
End If
bolquantity = Me.txtOutletQuantity.Visible
End Sub
Before that I tried basing a combo box on another combo box which queries the different sizes of ball valves based on the type of ball valve chosen, but that failed also.
I'm not sure why this is happening, maybe there is something wrong with my database?
My recent attempt was to get a textbox to appear visible only when "None" was selected on the combobox next to it.
The code for this was:
Private Sub CboOutletSize_AfterUpdate()
Dim strsize As String
Dim bolquantity As Boolean
strsize = Me.CboOutletSize.Value
If strsize = "None" Then
bolquantity = False
End If
bolquantity = Me.txtOutletQuantity.Visible
End Sub
Before that I tried basing a combo box on another combo box which queries the different sizes of ball valves based on the type of ball valve chosen, but that failed also.