Clearing information from Subform

  • Thread starter Thread starter tmdrake
  • Start date Start date
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.
 
me!subform.datasource = ""

That would need to be:

Me!Subform.Form.RecordSource = ""
 
Back
Top