Set a variable to a table field object

  • Thread starter Thread starter accesswanabe
  • Start date Start date
A

accesswanabe

How can I set an object variable that refers to a specific table field (not
it's value) to be used in my DAO code?

Thanks!
 
Dim vFld as DAO.Field

Set vFld = CurrentDB.TableDefs("SomeTableName").Fields("someFieldName")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Thanks, John! I really appreciate your help!

John Spencer said:
Dim vFld as DAO.Field

Set vFld = CurrentDB.TableDefs("SomeTableName").Fields("someFieldName")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
Click to expand...
 
Back
Top