[AccessD] Locking a textbox based on other form controls

Only if you don't set the form's recordset or RecordSource property from
code.  And Text is a read only property of Access textboxes.  It can
only be read when the control has the focus.  Otherwise, you have to use
the Value property.  What you're describing sounds a lot like what
happens when a bound textbox has a change made in code to the underlying
recordset and the user then tries to change the value from the UI and
save the record.  The two changes collide and Access complains mightily.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Christopher
Jeris
Sent: Thursday, August 17, 2006 7:49 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Locking a textbox based on other form controls


The form's .RecordSource property is blank; that makes the form unbound,
right?

peace, Chris Jeris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFE5IH35ICCNV0oGWARApicAJ442hQ6kDdro9CJP2ERl+W+SodDKwCeNyoo
pjCMD05brLe1V5E8xi3gvKw=
=qv1Z
-----END PGP SIGNATURE-----
--