Hi,
I have a datasheet view subform which contains a combo box with 4 potential
choices.
If choices A or B of the combo box is selected, I want field X to be
available to add data to, but if choice C or D of the combo box is chosen, I
want field X to be unavailable to add data to - whether this be "greyed out"
or hidden I don't mind.
I have previously posted and been given the info below, which is great, but
only seems to work in form view, and I need my subform to be DATASHEET VIEW.
"Put code similar to this in the after update event of your combo box and also
in the On current event of the form
If Me.ComboBoxName = "Hire Weekly" or Me.ComboBoxName = "Hire Daily" Then
Me.TextBoxName.Visible = True
Else
Me.TextBoxName.Visible = False
End If"
Many Thanks :O)
Sarella
I have a datasheet view subform which contains a combo box with 4 potential
choices.
If choices A or B of the combo box is selected, I want field X to be
available to add data to, but if choice C or D of the combo box is chosen, I
want field X to be unavailable to add data to - whether this be "greyed out"
or hidden I don't mind.
I have previously posted and been given the info below, which is great, but
only seems to work in form view, and I need my subform to be DATASHEET VIEW.
"Put code similar to this in the after update event of your combo box and also
in the On current event of the form
If Me.ComboBoxName = "Hire Weekly" or Me.ComboBoxName = "Hire Daily" Then
Me.TextBoxName.Visible = True
Else
Me.TextBoxName.Visible = False
End If"
Many Thanks :O)
Sarella