[AccessD] can't select data in control when AllowEdit false

I had this problem on forms which the user may or may not be allowed to edit
based on their access level when they log in at the opening form.  

If they're not allowed edits they still need to select a record from a combo
box.  So in the On_Click event of the combo box I set Me.AllowEdits = True,
and then in the Lost Focus of the combo, set AllowEdits = False.  

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Friday, September 10, 2010 4:06 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] can't select data in control when AllowEdit false

Set the form to allow edits but set individual controls to Enabled = Yes and
Locked = Yes?

On 10 Sep 2010 at 6:37, jwcolby wrote:

> I had forgotten this.
> 
> Is there a way around it?  It is not uncommon to not allow the user to 
> edit the form's underlying record and yet need to click a button or 
> select an item from a list.
> 
> --
> John W. Colby
> www.ColbyConsulting.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


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