Ok guys I have this mostly working with one small glitch and I am sure its easy but I have been looking at it for to long to see the issue.
I have a form with a text box named [PH] (properties set to not visible)
. a combo box named [CS Multiple Phases List] (properties set to not visible)
.. and a check box named [CS Multiple Phases]
What I want it to do I when the check box is not checked show the [PH] thus [CS Multiple Phases List] is still hidden, when it is checked the [CS Multiple Phases List] is shown and thus the [PH] is hidden.
The users make he check box selection on the form.
Currently when opened it works perfectly rather the box has been checked before or if it is blank.
The problem is when the check box is selected you must unselect and select it again before the fields hide and unhide as they should.
Here is the code, please show me what I am overlooking.
Code:
OptionCompare Database
Private SubForm_Current()
[CSMultiple Phases List].Visible = Me.[CS Multiple Phases] = True
[PH].Visible= Me.[CS Multiple Phases] = False
[CS Status]= "New Request"
End Sub
Private SubForm_Dirty(Cancel As Integer)
[CSMultiple Phases List].Visible = Me.[CS Multiple Phases] = True
[PH].Visible= Me.[CS Multiple Phases] = False
Me.Refresh
End Sub
.