Treating dataview like a table

disgruntled

Registered User.
Local time
Today, 21:59
Joined
Jul 3, 2001
Messages
38
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
 
No worries all......solved it. You can use the me.recordsetclone function and manipulate it like a regular recordset. Thanks though.
 

Users who are viewing this thread

Back
Top Bottom