I have a main form with a subform that is a continuous form. When the user opens the main form, enters a value in the combox on the subform (continuous form) a new combo box appears. The user enters a value into the second combo box, and a new...
I have a main form with a subform that is a continuous form.
When the user opens the main form, enters a value in the combox on the subform (continuous form) a new combo box appears. The user enters a value into the second combo box, and a new como box appears. The user enters a value into the third combo box. The user closes the form saving teh changes.
Is there a way to open the main form, delete the values from the second and third combo boxes, close the main form, and when the main form is re-opened the two empty combo boxes no longer displays.
I have tried to requery the subform, but that does not seem to help.