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.

"Jess" wrote in message
...
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" wrote:

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" wrote in message
...
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.


.