In VB I have a recordset and want to work with specific fields.
I realize I can use an index number e.g. rst(23)but I don't like using
index numbers in case I change the underlying fields or table later.
I also realize you can use a text name of field e.g. rst!"Myfield".
But where I am having trouble is when the field has a name such as
TblProducts_Location where TblProducts is the table in which the field
"Location" resides.
How do I use that name as a recordset field?
Thank you for the help in advance.