Perhaps there is code running in the form's Load event or Current event that
sets the RowSource value list for the combo box. If so, that would override
what you typed into the design of the form.
--
Ken Snell
http://www.accessmvp.com/KDSnell/
"Mr Smith" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I've inherited an Access Database, and am struggling to make what I
> thought would be a simple change.
>
> There is one item on the form defined as a "Combo Box". It expects
> values A, B or C at the moment, but my boss has asked if I can extend
> it to include D.
>
> So.... I opened the form in Design View, and saw that the field had a
> "Lookup Row Source" of "A";"B";"C".
>
> Very smugly I added ;"D" to the string, only to find it just will not
> take effect, no matter what I close and re-open. Thwarted, or what?
>
> I've had a dabble on-line and seen similar posts on this subject, but
> the solutions all seem to involved embedding code somewhere (which
> would be a "first" for me!)
>
> Is there really no way I can do this just by altering a few field
> definitions? Alternatively, if I changed it to a "List Box" or
> something (don't really know the difference, if I'm honest) would that
> solve things?
>
> Thanks for any suggestions!
>
Similar Threads
