In general, you don't work with tables in VB (or, more accurately if we're
talking about Access, VBA). You'd open a recordset based on that table (or
on a query based on that table) and work with the recordset.
However, if all you want is to know the value of a field in the table, you
could use the DLookup function.