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

Lookup Lists

P: n/a
MJ
How can you update a Lookup List after it is created. It is not tied
to any table. I have tried adding the new data at the table level, but
when I go to the Form to input, it isn't on the list. Any suggestions?

Nov 13 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a
MJ wrote:
How can you update a Lookup List after it is created. It is not tied
to any table. I have tried adding the new data at the table level,
but when I go to the Form to input, it isn't on the list. Any
suggestions?


I'm guessing you have to also add it to the form.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
MJ
I did that--added it to the form and it did pick up the new
information, but now I can't change the label--it says "Combo 18" and I
wanted it to say "Component"

Nov 13 '05 #3

P: n/a
MJ
I entered the list using the Wizard Lookup feature. I entered the
values myself. I tried entering the new item in the Row Source
matching the format.

I have successfully added the field to the form, but the label is
showing "Combo 18" even though that isn't anywhere in the Design View.

I went to the Table and input the caption as Component and in Design
View that shows correctly, but when I go to Form View it still says
"Combo 18"

Nov 13 '05 #4

P: n/a
MJ wrote:
I entered the list using the Wizard Lookup feature. I entered the
values myself. I tried entering the new item in the Row Source
matching the format.

I have successfully added the field to the form, but the label is
showing "Combo 18" even though that isn't anywhere in the Design View.

I went to the Table and input the caption as Component and in Design
View that shows correctly, but when I go to Form View it still says
"Combo 18"


When you type the values yourself you are creating a ValueList as the RowSource
for the list. You didn't need to create a new ComboBox on the form. All you
needed to do was add the new entry to the ValueList for the existing one.

Did you delete the original ComboBox?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #5

P: n/a
MJ
I made a copy of the database before I tried changing things.
Originally the table shows this Lookup as:

Display Control: Combo Box
Row Source Type: Value List
Row Source : "TruHeat"; etc., etc.

I added the new component with quotes around it in the Row Source with
a semicolon in front--just list it showed, but when I went to the form
to select the new item, it wasn't there.

Nov 13 '05 #6

P: n/a
MJ wrote:
I made a copy of the database before I tried changing things.
Originally the table shows this Lookup as:

Display Control: Combo Box
Row Source Type: Value List
Row Source : "TruHeat"; etc., etc.

I added the new component with quotes around it in the Row Source with
a semicolon in front--just list it showed, but when I went to the form
to select the new item, it wasn't there.


See if it is still there in design view. Often if you enter a property
incorrectly it will silently drop your changes as soon as you tab out of the
property.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #7

P: n/a
MJ
Yeah! I figured it out. I was going back to the table to make the
change. I tried clicking Field on the form in Design View and went to
Properties and added it there. That is just what it needed. Maybe I
could have just added it there and not at the Table, but it doesn't
matter--it works!!!!!! Thank you so much! I have sooooo much t learn.
Thank you for your time and patience!!!!!

Nov 13 '05 #8

P: n/a
MJ wrote:
Yeah! I figured it out. I was going back to the table to make the
change. I tried clicking Field on the form in Design View and went to
Properties and added it there. That is just what it needed. Maybe I
could have just added it there and not at the Table, but it doesn't
matter--it works!!!!!! Thank you so much! I have sooooo much t
learn. Thank you for your time and patience!!!!!


Start here...

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

....paying particular attention to comandment number 2.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #9

P: n/a
MJ
I just read the 10 Commandments and #2 was good to read. I had always
thought Lookups were great--cutting down on keyboarding errors. I am
finding out the hard way they aren't all they could be.

I am taking on-line classes and learning as fast as I can. This
project has taken over my life almost. I don't think I will ever be as
talented as most of the people responding to the questions. It is nice
to see those who have the knowledge, sharing it. Have a great new
year!

Rick Brandt wrote:
MJ wrote:
Yeah! I figured it out. I was going back to the table to make the
change. I tried clicking Field on the form in Design View and went to Properties and added it there. That is just what it needed. Maybe I could have just added it there and not at the Table, but it doesn't
matter--it works!!!!!! Thank you so much! I have sooooo much t
learn. Thank you for your time and patience!!!!!


Start here...

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

...paying particular attention to comandment number 2.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Nov 13 '05 #10

P: n/a
IMO Lookup "TABLES" are a great way to:
1. Reduce keying errors,
2. Providing human friendly output on reports
3. Store variable values for calculations on reports, and in queries
4. Reducing data storage space
5. And a number of other uses

Lookup "CELLS/FIELDS" just plain suck.
On 30 Dec 2004 19:11:16 -0800, "MJ" <je*******@cox.net> wrote:
I just read the 10 Commandments and #2 was good to read. I had always
thought Lookups were great--cutting down on keyboarding errors. I am
finding out the hard way they aren't all they could be.

I am taking on-line classes and learning as fast as I can. This
project has taken over my life almost. I don't think I will ever be as
talented as most of the people responding to the questions. It is nice
to see those who have the knowledge, sharing it. Have a great new
year!

Rick Brandt wrote:
MJ wrote:
> Yeah! I figured it out. I was going back to the table to make the
> change. I tried clicking Field on the form in Design View and wentto > Properties and added it there. That is just what it needed. MaybeI > could have just added it there and not at the Table, but it doesn't
> matter--it works!!!!!! Thank you so much! I have sooooo much t
> learn. Thank you for your time and patience!!!!!


Start here...

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

...paying particular attention to comandment number 2.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Have a nice day. ld****@NOPANTS.juno.com

Remove NOPANTS To reply by direct E-Mail;
Support: The Right to Privacy and Anti-SPAM projects.
Nov 13 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.