Class => getting account balance

Hi group,

I'm trying to use classes (just for testing). I've build a very small bank application. I get the account info by using a connection and a recordset, (SELECT name, accountno from Account) very easy.

I know want to retrieve the accountbalance for that person by using a class and a property (balance or something).

Can anybody show me how to do this?

Thanks in advance

Regards,

visualsander