query call from vba

[casey rudge]

i am currently working on a real-time accounting form -- i
want to pull a query (qry_uncommit_bal)from the querytab
and store it in a variable so it can be calculated in a
balance.

here is the code

Private Sub CheckBal()

Dim UqResult As Currency
curUncomBal = (total_uncommitted.Value)
Label37.Caption = FormatCurrency(curUncomBal)

curComBal = (total_committed.Value)
Label38.Caption = FormatCurrency(curComBal)


End Sub

any help would be appreciated

thanks,
case

 

[TC]

Casey, try:

dim db as DAO.database, rs as DAO.recordset ...

and see if that helps.

HTH,
TC


(snip)