Can't see choices in lookup drop-down

[csarjeant via AccessMonster.com]

I am creating a database that includes two tables of names, one for our
Admins and one for our Inspectors. In the other tables/forms, I am putting
text boxes as lookup fields so that the user can select their name from a
dropdown as they complete the various forms in the database. Except, when the
down arrow is selected for the lookup, you can't see the names. The dropdown
acts as if there is text there, the Admin table has 2 names and its dropdown
has blank spaces for 2 names. The inspector table has 3 names and its
dropdown has blank space for 3 names. When you position the cursor where the
name text should be in the drop-down and left-click, the name magically
appears in the text box. I used the lookup wizard to create the fields and I
can't figure out why I can't see the text, but it acts like its there. Any
help is appreciated.

 

[csarjeant via AccessMonster.com]

ADDITIONAL INFO: I forgot to mention that the two tables of names consist of
only one field each, the field containing the name of the individual - first
initial, last name. This single field is also the key field, if that makes
any difference. The Admin table has 2 names and the Inspector's table has 3
names. Thanks.

 

[Gina Whipp]

csarjeant,

Sounds like your column count is set for two and you only have one field in
each table.

On another note, I have to wonder about your table set up that you have two
seperate tables where one table with do.

tblIndividuals
iFirstName
iLastName
iIndividualTypeID (Admin or Inspectors)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Forgot to mention... making the individuals name Primary Key is a bad idea.
In a large Company or a Company with a large customer base there will
certainly be duplicates.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[csarjeant via AccessMonster.com]

Gina,
Thanks for the help. Here is what I tried:
I created a single tabel as you suggested,

tblQCStaff
Item(Autonumber) - key field
FirstName
LastName
JobTitle(Inspector or Admin)

I still have the same problem. I noticed that when the table included the
Autonumber as the key field, after the lookup wizard created the combo box,
the field data type show as "number", even though I only include the
FirstName and LastName in the list. I assume this is because it is storing
the number from the autonumber field. When I remove the Autonumber field from
the table and make LastName the key field, the field data type changes to
"text" but I still can't see anything. I have been playing with this all
morning and can't make any progress.
Using my original table from yesterday, I changed column count to one, but it
still doesn't help.

Thanks,
Chris

csarjeant,

Sounds like your column count is set for two and you only have one field in
each table.

On another note, I have to wonder about your table set up that you have two
seperate tables where one table with do.

tblIndividuals
iFirstName
iLastName
iIndividualTypeID (Admin or Inspectors)

I am creating a database that includes two tables of names, one for our
Admins and one for our Inspectors. In the other tables/forms, I am putting

[quoted text clipped - 13 lines]

can't figure out why I can't see the text, but it acts like its there. Any
help is appreciated.

 

[Gina Whipp]

Please fill in the below information for your Combo Box

Control Source...
Row Source Type...
Rwo Source...
Column Count...
Column Widths...
Bound Column...

Then what is the name of the table you are storing this information in and
the field name.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,
Thanks for the help. Here is what I tried:
I created a single tabel as you suggested,

tblQCStaff
Item(Autonumber) - key field
FirstName
LastName
JobTitle(Inspector or Admin)

I still have the same problem. I noticed that when the table included the
Autonumber as the key field, after the lookup wizard created the combo
box,
the field data type show as "number", even though I only include the
FirstName and LastName in the list. I assume this is because it is storing
the number from the autonumber field. When I remove the Autonumber field
from
the table and make LastName the key field, the field data type changes to
"text" but I still can't see anything. I have been playing with this all
morning and can't make any progress.
Using my original table from yesterday, I changed column count to one, but
it
still doesn't help.

Thanks,
Chris

csarjeant,

Sounds like your column count is set for two and you only have one field
in
each table.

On another note, I have to wonder about your table set up that you have
two
seperate tables where one table with do.

tblIndividuals
iFirstName
iLastName
iIndividualTypeID (Admin or Inspectors)

I am creating a database that includes two tables of names, one for our
Admins and one for our Inspectors. In the other tables/forms, I am
putting

[quoted text clipped - 13 lines]

can't figure out why I can't see the text, but it acts like its there.
Any
help is appreciated.