Subform query (1 Viewer)

[ian_ok]

In my subform I have a default for todays date, which is updated when a combo box option is picked.

What I want is to hide this date box until the combo option is clicked....any ideas?

Ian

 

[AlanS]

Assuming the date is in textbox txtDate, the combo box is called cboCombo, and the combo box option value that will make the date visible is 3, put this code into the AfterUpdate event procedure for cboCombo:

txtDate.Visible = cboCombo = 3