Access Combo Box question

M

Mr Smith

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top