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