Subform: showing no records when first opening my form

[quandore]

Hi, is there any piece of code that can prevent a subform to display all records every time i open my form?


My form has 3 combo boxes and 4 text boxes from which i filter the subform by clicking a filter command that requeries the form itself. the problem is: i also have 2 calculation fields that compute a DSUM in the subform's query. so if it shows all the records then the calculations will take a huge amount of time to perform. so i need to have the subform empty when i open the form, then i can filter it with my combo boxes and the calculations will apply to the filtered query.
hope i made myself clear enough.

any suggestion?

[RuralGuy]

You might look at removing the RecordSource of the SubForm until you've made your first selection. You could also set the DataEntry property until you've made the first selection. Either one can be done in the OnLoad event of the MainForm.