View Full Version : Subform query


ian_ok
06-04-2001, 03:04 AM
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
06-04-2001, 05:17 AM
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