General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
Refering to fields in a recordset
I have a recordset based on an SQL query, it includes more than one table. How do I refer to this in code?
In the past I have only used recordsets consiting of one table and so I have used the sytanx
recordsetname!fieldname
but there could be more than one field with the same name in the recordset that I am using now, but from different tables,
I tried
recordsetname!tablename.fieldname and
recordsetname!tablename!fieldname
but had no luck with either.
Can someone help please?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only