query call from vba

  • Thread starter Thread starter casey rudge
  • Start date Start date
C

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
 
Casey, try:

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

and see if that helps.

HTH,
TC


(snip)
 
Back
Top