Results 1 to 2 of 2
  1. #1
    abic131 is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    20

    Allow users to edit values of a listbox in a form


    I have a series of 2 list-boxes and a combo box in an Access form that are cascading. I would like to be able to edit the listboxes from the form by double-clicking on the specific value. I know that if I say Yes to the 'Allow Value List Edit' I can use a new form that will allow users to edit/add data. However I'd prefer to allow users to directly edit values on the form by double clicking on the values. I'm pretty sure I'll need to create a Double Click Event but I'm not sure what to use as the code. Any ideas are much appreciated!

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Be cautious when letting users type in new or edit existing values. Experience shows users make lots of typos. You may be in for more work to fix things up than you know.
    Many useful designs --those considered easy to use -- have pre-populated lists and no typos/spelling issues arise.
    Good look with your project.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 02-26-2014, 07:12 PM
  2. Replies: 10
    Last Post: 12-24-2013, 12:53 PM
  3. Replies: 14
    Last Post: 12-26-2011, 07:32 PM
  4. Replies: 1
    Last Post: 03-24-2010, 08:42 AM
  5. Allow some users to edit, and other to only view?
    By Tommy1005 in forum Security
    Replies: 2
    Last Post: 11-09-2009, 09:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums