Clear Subform

[puthenveetil]

Hi all,

I had a form which had a subform in it..The form is for searching..Is there any way to clear the results in the subform from a command button in mainform.Now I had to close the form and open it again if I want to search again....


Thanks in advance


Thanks

 

[reclusivemonkey]

You should be able to refresh the subform whenever you change the search criteria. Using '.Requery' on the AfterUpdate event of your criteria field should work.

 

[MartijnAn]

You should be able to refresh the subform whenever you change the search criteria. Using '.Requery' on the AfterUpdate event of your criteria field should work.

I Understand, but whatif the query you use on the specific field already has a query which does not return the default value?