Glad it got worked out!

--
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
...
Never Ming Gina... I had it right all along the way you said it.
I dont know why I was seeing the PK in there.

"Gina Whipp" wrote:

Damian,

You CAN do it like that but it begs the question why you would WANT to do
it
like that? Normally, showing the PK in a table is not needed or
neccessary.
The End-User should never even see it, nor should they care what the
Autonumber is.

--
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
...
Thank you Gina.

Is there a way to have a box next to it that would display the actual
name?
First box would be the autoNumber assigned for the specific name and
next
to
it would be a box that would display the name.

Thanks

"Gina Whipp" wrote:

1. Where it says Row Source just put tblCrewType
2. Return the Control Source fo your Combo Box to ctCrewTypeID

--
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
...
Still cant get it to work,

here come the screen shot...
http://img262.imageshack.us/img262/470/form1.png

Gina: Going back to my original post about the design of tables and
the
relationship. I posted a screen shot of the corrections I made. If
you
dont
mind taking a last look at it, its on 2nd page of this forum.
Thank you,

"Gina Whipp" wrote:

Doing it they way you did will not allow you to make and changes to
the
Combo Box.

I just realized your Combo Box is incorrect... I had more coffee.
Please
set it up the way I said in my first reply with the 2 columns...

--
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
...
The control Source was cCrewTypeID.
I played around with it and changed it to "=
[TblCrewType]![ctType]
"
Which gives me the list in combo box BUT I cant chose any, its
wont
let
me.

"Gina Whipp" wrote:

Damian,

Okay, the first thing is change the Column Widths on the Comb
Box
to
1.
The
second thing is what is the Control Source of the Combo Box?

--
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
...
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.