how to define table and field to program

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following line in a program
If IsNull([Test3.cash_bal_amt]) Then GoTo Op22 Els
Test3 is a table, cash_bal_amt is a field in that table. I have tried several ways of putting the name of the field in and it is always rejected as an undefined external file. Test3 exists in the database where the program is located. The database has been defined as Set dbs = CurrentDb and the recordset as Set rst = dbs.OpenRecordset("Test3", dbOpenTable). what changes need to be made to be able to use the table for reading and writing?
 
vjt said:
I have the following line in a program:
If IsNull([Test3.cash_bal_amt]) Then GoTo Op22 Else
Test3 is a table, cash_bal_amt is a field in that table. I have tried
Click to expand...
several ways of putting the name of the field in and it is always rejected
as an undefined external file. Test3 exists in the database where the
program is located. The database has been defined as Set dbs = CurrentDb
and the recordset as Set rst = dbs.OpenRecordset("Test3", dbOpenTable).
what changes need to be made to be able to use the table for reading and
writing?

If you are opening a Recordset against the table in your code then your
code can only access the Recordset, not the table it is based on. Try
using...

rst!cash_bal_amt
 
Back
Top