[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