Beach Access Software
bchacc at san.rr.com
Mon Nov 27 16:34:15 CST 2006
Bob: Right off the top of my head, I think, after you get the field name from the first recordset into a string variable like strFieldName, then in the second recordset you'd want to use rs2(strFieldName) to get reference the value from that field of the record that recordset rs2 is currently pointing to. Clear as mud? Call me if you want to - 858-259-4334. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood Sent: Monday, November 27, 2006 2:20 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] DAO Field Name String/Variable in my example the field names are in table 1. Sorry i'm Vegas working on a laptop..... Will visit soon. bob -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Beach Access Software Sent: Monday, November 27, 2006 12:20 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] DAO Field Name String/Variable So table one contains the field names of table 2? Rocky P.S. Swing by my office with your laptop and I'll do it for you on the spot (yes I have an ulterior motive). -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood Sent: Monday, November 27, 2006 11:24 AM To: Access Developers discussion and problem solving Subject: [AccessD] DAO Fiekd Name String/Variable Hello to the list, I woild like to: 1. get a value from one table as a string 2. lookup the value of a field in a second table where the field name = the value of field in table 1 Using !s if possible. TIA best Bob -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.430 / Virus Database: 268.14.16/552 - Release Date: 11/26/2006 11:30 AM -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.430 / Virus Database: 268.14.16/552 - Release Date: 11/26/2006 11:30 AM