Its not working. Nothing shows up in the Combo Box.
My Raw Source is " SELECT TblCrewType.ctType FROM TblCrewType; "

Does Colums count or Bound Column has anything to do with it?

"Gina Whipp" wrote:

Damian,

In your combo box where is say Column Widths put 0;1

This will make cType show up but it will store the number.

--
Gina Whipp

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

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

"Damian" wrote in message
...
Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType

TblCrewType
ctCrewTypeID PK Auto #)
ctType text

When I create a Form Using cFName, cLName and cCrewTypeID HOW can I make
the
box for cCrewTypeID display whats in ctType?

cCrewTypeID is an auto Number and is assigned to each ctType BUT on a form
I
dont want to see 1 or 5 I would like to see the type/text behind it like
Carpenter.

I tried look up combo box and I can see the ctType but when I select it
nothing happens since cCrewTypeID is set to accept only numbers and not
text.

How can I go around that?
Thank You.