Bob Heygood
bheygood at abestsystems.com
Mon Sep 11 13:07:02 CDT 2006
Hey Rocky, Thanks for the jump start. This did the trick: Me!txtInfo5.ControlSource = gField5 best, bob -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Beach Access Software Sent: Sunday, September 10, 2006 9:08 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] change control source via vba Bob: I think the right syntax is, in the Load or Open event (can never remember which is best) txtMyTextBox.ControlSource = "fieldnamefromyourtable" Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood Sent: Sunday, September 10, 2006 4:37 PM To: Access Developers discussion and problem solving Subject: [AccessD] change control source via vba Does anyone have a code snip that will show me how to change a report control from being unbound to one of the fields in the record source of the report?? This needs to be done either when opening the report or from code I run before opening. TIA 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.1.405 / Virus Database: 268.12.2/442 - Release Date: 9/8/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.12.2/442 - Release Date: 9/8/2006 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com