Entered myself Combo list

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

Hello,

When setting up my Table in DView, one field was a Look-Up
Wd. I chose to type in the values myself. So great now
have a combo box with a list of names. Adding a name to
that list, how do I do it and where. 2nd question
relating to this matter. Let's say I want to change this
combo box to retrieve the names in a table instead, is
that possible?

Thanking all those who can help!!
Kindest regards,
Linda
 
If you used the lookup feature of the table, the only place you can add to
it is in the design view of the table. This is BAD practice and for this
(and many other reasons), most experienced developers do not use the LookUp
feature of tables. Instead, create a separate table to store these value
and create a relationship between the tables. You can use the combo box
with the lookup table as the row source and join this table into a query to
report these values. This makes it possible to easily maintain the lookup
values.
 
Roger,

I already have data that is entered and queries, how to I
go about turning this list into a table?

Thanks!!
Linda
 
I don't know that there is any easy way. You will want to create a table
with an autonumber field and the text you want it to represent. Then you
have to put this number in each record in the main table so they can link.
Then you will have to recreate the row source of each of your combo boxes to
get it's values from the lookup table. And lastly, you will have to
re-write any queries by adding and JOINING your lookup table to the main
table.

It could be a lot of work, depending on how far along you are, but it will
be worth it in the long run.

On my website (see sig below) in the Tutorials (Application) section, you
will find some step-by-step lessons for creating an application. Part of
those will show how the combo boxes work.
 
Back
Top