Bob Heygood
bheygood at abestsystems.com
Mon Nov 27 16:20:14 CST 2006
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