[AccessD] Allow Edits

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Tue Jul 24 19:47:55 CDT 2007


Dear List:
 
I have an unbound combo box on a form with a list of employees.  If the
current user chooses their own name (it's stored in a table, I can do a
DLookup) then I allow additions and edits.  If they don't choose their own
name I set allow additions and edit to false.  Works great that far.
 
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.
 
I tried putting Me.AllowEdits = True in the click event of the combo box but
the click event is firing AFTER the ArfterUpdate event so that's not
working.
 
Brute force solution would be to disable all of the text boxes on the form
if the chosen user isn't the current user and V.V.  But is there a more
elegant way?
 
MTIA
 
Rocky
 


 	
	



More information about the AccessD mailing list