combo box wizard doesnt recognize some fields in a table

[Toadums]

Hey guys.

I am trying to populate a combo box with values from a table..

So using the wizard I create a combo box and then a box pops up asking if i want to link its values to a table or if i want to type them in manually. so i select from a table, then i select the table...except it only shows 4/6 of the fields...It doesnt have FirstName or LastName.

Any ideas why? here is a screen of my table.

(btw, I want the combo box to be populated with the peoples first name, ya know? so i can run a query by first name via the form).

thanks!
Paul

 

[boblarson]

Do NOT do this in the table. Table level lookups are not good. See here for why.

You can do this on a FORM with a combo but not in a table.

 

[Toadums]

ok, so is that link (and you) saying that I should not have my combo box populated from values in a table? Im not really understanding what you mean by "You can do this on a FORM with a combo but not in a table."

My combo box is on a form...

so what do you suggest I do? because this table is linked to my master DB via an ODBC connection, so I definitely need to use the values which are in this table...

thanks

 

[boblarson]

Your screenshot showed the table, not the form, so I assumed you were talking about a combo box on the table.

 

[boblarson]

You don't need to use a wizard to create a combo box. Here's a set of screenshots that show how to change a text box on the form to a combo for your name.

CONTINUED ON NEXT POST

 

[boblarson]

Continued from previous post

 

[Toadums]

wow, that was a great help, got it working perfect.

very good, clear tutorial!

thanks
Paul

 

[boblarson]

Glad you got it working