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.
