Treating dataview like a table

[disgruntled]

Hi all......I have a form with various combo boxes used for criteria. In the form is a subform which holds a table in datasheet view and updates as i choose from the combo box criteria's. There is a textbox on my form which i would like to fill with the average of on of the columns in the subforms. How would i do that?
Cheers

 

[disgruntled]

No worries all......solved it. You can use the me.recordsetclone function and manipulate it like a regular recordset. Thanks though.