By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,334 Members | 2,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,334 IT Pros & Developers. It's quick & easy.

Drop down list for a table?

P: n/a
I have a table that I am manipulating as a table, not as a form. Is it
possible to have a drop down list in a table?

I came across this:
http://groups.google.com/group/comp....0bced904cccbfa

The person answering the question seems to imply that a form should be
used if a drop down list is needed. Am I correct in thinking that a
form should be used?

Thanks.

Aug 8 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi,
I have a table that I am manipulating as a table, not as a form. Is it
possible to have a drop down list in a table?

I came across this:
http://groups.google.com/group/comp....0bced904cccbfa

The person answering the question seems to imply that a form should be
used if a drop down list is needed. Am I correct in thinking that a
form should be used?
Even though you could use lookup fields in a table, it's highly recommended
not to use them, as you can read here:

http://www.mvps.org/access/lookupfields.htm

So use a form to avoid any problems...

Regards
Jens

Aug 8 '07 #2

P: n/a
ja*******@instruction.com wrote:
I have a table that I am manipulating as a table, not as a form. Is it
possible to have a drop down list in a table?

I came across this:
http://groups.google.com/group/comp....0bced904cccbfa

The person answering the question seems to imply that a form should be
used if a drop down list is needed. Am I correct in thinking that a
form should be used?

Thanks.
Yes, you can create a dropdown. When you add a field in the table,
you'll see a General tab and a Lookup tab, Select lookup.

Others may supply you with the pros/cons of doing so.

Aug 8 '07 #3

P: n/a
Salad <oi*@vinegar.comwrote in
news:13*************@corp.supernews.com:
ja*******@instruction.com wrote:
>I have a table that I am manipulating as a table, not as a
form. Is it possible to have a drop down list in a table?

I came across this:
http://groups.google.com/group/comp.databases.ms-
access/browse
>_thread/thread/509fbf44455ab35d/2e0bced904cccbfa?
lnk=gst&q=Dro
>p+down+list+table&rnum=4&hl=en#2e0bced904cccbfa

The person answering the question seems to imply that a form
should be used if a drop down list is needed. Am I correct in
thinking that a form should be used?

Thanks.
Yes, you can create a dropdown. When you add a field in the
table, you'll see a General tab and a Lookup tab, Select
lookup.

Others may supply you with the pros/cons of doing so.
Pro: nothing
Con: too many to list, including: failed searches, failed
filters, all sort of problems with queries, forms and reports.

Besides, manipulating a table, without using a form can be
difficult as you cannot control many aspects of accidental
change, automation, etc. --
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Aug 8 '07 #4

P: n/a
On Wed, 08 Aug 2007 06:54:43 -0000, ja*******@instruction.com wrote:
I have a table that I am manipulating as a table, not as a form. Is it
possible to have a drop down list in a table?

I came across this:
http://groups.google.com/group/comp....0bced904cccbfa

The person answering the question seems to imply that a form should be
used if a drop down list is needed. Am I correct in thinking that a
form should be used?

Thanks.

I haven't read your specific google link, but ....
yes, a form should be used for data entry, data editing, etc.
A table should be used for data storage.

You haven't said what you are 'manipulating' so there is nothing else
I can suggest, other than if you want the 'View' of a table, setting a
form to Datasheet View, if that will help.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Aug 8 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.