[AccessD] Syntax for Allow Edits Subform

rusty.hammond at cpiqpc.com rusty.hammond at cpiqpc.com
Fri Jan 5 11:33:19 CST 2007


Rocky,

Me either, so what I do is open the form in design view, create a temporary
macro, choose SetValue in the Action column, then in the Item property I
click the expression builder and use that to choose the control I'm trying
to reference.  That gives me the syntax I need to use.

HTH

Rusty

-----Original Message-----
From: Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Friday, January 05, 2007 11:07 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Syntax for Allow Edits Subform


Rusty:

That worked.  Thank you.  (I'll never get that syntax!!)

Rocky


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
rusty.hammond at cpiqpc.com
Sent: Friday, January 05, 2007 8:47 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Syntax for Allow Edits Subform

Rocky,

Try taking the s off the end of forms ie:
Me.subfrmBundleVerification.Form.AllowEdits = False

That's the only thing I can see different from what I have in a working app
(A97)

Rusty

-----Original Message-----
From: Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Friday, January 05, 2007 10:37 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Syntax for Allow Edits Subform


Dear List:

 

I need to set Allow Edits to false on a subform.

 

Both Me.subfrmBundleVerification.AllowEdits = False and
Me.subfrmBundleVerification.Forms.AllowEdits = False

 

fail.  What is the correct syntax?

 

MTIA

 

Rocky

 

 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************
-- 
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.432 / Virus Database: 268.16.5/616 - Release Date: 1/4/2007
1:34 PM
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************



More information about the AccessD mailing list