[AccessD] Allow Edits

David:

Perfect! Enter and Exit versus Click and AfterUpdate.  Who knew?

Thanks so much for the quick response.  My bacon been saved again!

Rocky



 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: Tuesday, July 24, 2007 6:09 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Allow Edits

Rocky,

Put some code on the Enter event of the combo box to allow edits, then on
the Exit event determine from the value of the combo box whether to set
AllowEdits to true or false.

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand

At 25/07/2007, you wrote:
>
>Problem is that the combo box isn't editable so after a name is chosen 
>which is NOT the current user and AllowEdits is set to  False, they 
>can't choose another record.  The combo box won't update.
>
>========If you're inhibiting edits, why would you want to allow one?
>
>Susan H.
>
>--
>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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.10.16/914 - Release Date: 7/23/2007
7:45 PM