Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Elkins Park, Pennsylvania, USA
    Posts
    325
    Thanks
    0
    Thanked 0 Times in 0 Posts

    List Boxes should trigger Edit Mode (Access 2003)

    Hi, all. I have a feeling i should know the answer to this, but I can't figure it out, so be gentle!

    In a nutshell, I have very simple database with a form linked to a table. The table has only three fields. Two of those fields have a limited number of choices for acceptable values. So, when I designed the form, I used a List Box for those two fields; I linked the Control Source to the appropriate field in the table; I set the Row Source Type to a Value List; and I entered the acceptable values in the Row Source property (e.g. the "Importance Rating" field can be "1;2;3;4;5;6;7")

    Oh, and because the records are so small, I set the form to display as a continuous form (for what that's worth.)

    Now the thing is, when the form is displayed and the user selects a different value from either List Box, I expected the record to kick into "Edit mode" (displaying the pencil icon to the left of the record.) What I see instead (aside from those two fields displaying as "highlighted" white text in a black text box, which perplexes me,) is that the form displays the new choice for the record, but it does not update the record with that value. And I found that what DOES work is if I click INSIDE the field first, before picking a new value form the list box.

    Can someone fill me in on what's going on and/or what I may have missed? is this going to be one of those things where I smack myself on the forehead afterwards? Thanks in advance for your help.
    <font face="Comic Sans MS">That's what you do in a herd; you look out for each other!</font face=comic> - Mike

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List Boxes should trigger Edit Mode (Access 2003)

    Have you actually bound the list boxes to the fields, i.e. set their Control Source to the name of the relevant field? It works for me if I do that (whether I use the mouse or the keyboard).

  3. #3
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Elkins Park, Pennsylvania, USA
    Posts
    325
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List Boxes should trigger Edit Mode (Access 2003)

    Yep. And that's what adds to my confusion. I'm attaching a screen cap that shows both the Form (continuous) and the data property of the first drop-down.
    Attached Images Attached Images
    <font face="Comic Sans MS">That's what you do in a herd; you look out for each other!</font face=comic> - Mike

  4. #4
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Elkins Park, Pennsylvania, USA
    Posts
    325
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List Boxes should trigger Edit Mode (Access 2003)

    OK, what I found, and what I'm going with, is that a Combo-box works just as I'd expect. I'll just set the "Limit to List" property to "Yes", and it will give me the functionality I expect (i.e. no weird highlighting, no having to click in a field before using its pick-list.)

    I guess I just can't impose my will on Microsoft Access.
    <font face="Comic Sans MS">That's what you do in a herd; you look out for each other!</font face=comic> - Mike

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List Boxes should trigger Edit Mode (Access 2003)

    Your screenshot showed list boxes that display only one item; in such a situation a combo box is more convenient, so that was going to be my next suggestion anyway.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •