VBA and field names in tables...

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

Guest

Help - I am an access VBA novice..

Trying to reference a field contained in a table from an OnChange event in a form...What is the syntax

I found a little of information on how to reference a field on the form but nothing on how to grab the same from a table...
 
If the field is in the form's recordset, just reference it directly:
[FieldName]

If the field is not in the form's recordset, you don't reference it
directly, and how you get its value completely depends upon what you're
doing. However, look at the DLookup function in VBA Help for more
information ... it may be what you seek.

--
Ken Snell
<MS ACCESS MVP>

yikes... said:
Help - I am an access VBA novice...

Trying to reference a field contained in a table from an OnChange event in a form...What is the syntax?

I found a little of information on how to reference a field on the form
Click to expand...
but nothing on how to grab the same from a table...
 
Back
Top