Allowing both multiple values and list edits in Lookup field

[Jess]

In Access 2007 I am trying to make a table column utilize a combo box that
allows both multiple values and list edits. However, when I set it to allow
both features, it doesn't let me make any edits to the list in the table; the
multiple values aspect works just fine. When I don't allow multiple values, I
can edit it to my heart's content.

Anyone know a way around this problem? I know that I'm doing it right (all
you have to do is select "Yes"!) but it's jut not allowing me to have both
allowances as it should.

 

[Jeff Boyce]

Jess

If you are saying that you are attempting to do this while working directly
in the table, STOP NOW!

The "lookup" data type in Access tables is held in general low regard if you
scan through this newsgroup.

Access tables are, for practical purposes, "buckets o' data". They may look
like a spreadsheet, but they are not...

Access forms are quite useful for displaying (add/edit/...) data. Using a
combobox control in a form is the way to handle looking up.

And if you are using a value list instead of a table to hold those "might be
looked up" values, consider shifting over to a table (call it a lookup
table). That way, you aren't burying the list of valid values somewhere
deep inside a control, inside a form.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Jess]

I have noticed a general dislike of using lookup in tables, but I hadn't
really been clear on the distinction between tables and forms. I haven't even
tried getting that technical with the form, so I will try that now! I'm a
beginner in Access, so I'm not yet very familiar with it.

Thank you for your clarification that using lookups in tables and in forms
are two completely separate issues, and for pointing out that tables are NOT
spreadsheets, as I have been treating them.

Jess

 

[Jeff Boyce]

So many folks find their way to Access from Excel. I generally advise them
that they are at a disadvantage when it comes to learning Access, for just
that reason <g>.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.