T
tmdrake
I have a main form where the user can make a selection from one or a
combination of four comboboxes. The base on the selection the information is
displayed in "datasheetview" on a subform.
On the main form there is a command button "Clear" that clear the selection
made in the comboboxes. This works fine.
Where I need help is when the user clicks the "Clear" button, not only do I
want it to clear the comboboxes on the main form, I also want the subform to
clear until a new selection is made on the mainform.
This is the code I am using to clear the comboboxes on the main form:
Me!ProjectId = Null
Me!DisciplineName = Null
Me!SectionNumber = Null
Me!LastName = Null
Call Select_Click
End Sub
How do I motify this to include clearing the subform?
Help is greatly appreciated, I just can't seem to get it right.
combination of four comboboxes. The base on the selection the information is
displayed in "datasheetview" on a subform.
On the main form there is a command button "Clear" that clear the selection
made in the comboboxes. This works fine.
Where I need help is when the user clicks the "Clear" button, not only do I
want it to clear the comboboxes on the main form, I also want the subform to
clear until a new selection is made on the mainform.
This is the code I am using to clear the comboboxes on the main form:
Me!ProjectId = Null
Me!DisciplineName = Null
Me!SectionNumber = Null
Me!LastName = Null
Call Select_Click
End Sub
How do I motify this to include clearing the subform?
Help is greatly appreciated, I just can't seem to get it right.