Creating a Form

Damian · External Since: Nov 09, 2004 Posts: 15

Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID <PK Auto#)
cFName
cLName
cCrewTypeID <Number><linked 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.

Gina Whipp · External Since: Sep 25, 2003 Posts: 426

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" <Damian.TakeThisOut@discussions.microsoft.com> wrote in message
news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
> Can't figure out how to do something.
> I have two tables:
>
> TblCrew
> cCrewID <PK Auto#)
> cFName
> cLName
> cCrewTypeID <Number><linked 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.

Damian · External Since: Nov 09, 2004 Posts: 15

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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
> > Can't figure out how to do something.
> > I have two tables:
> >
> > TblCrew
> > cCrewID <PK Auto#)
> > cFName
> > cLName
> > cCrewTypeID <Number><linked 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.
>
>
>

Gina Whipp · External Since: Sep 25, 2003 Posts: 426

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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
news:A94149EC-0E6E-44CB-93DF-DCBC435C460A@microsoft.com...
> 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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
>> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
>> > Can't figure out how to do something.
>> > I have two tables:
>> >
>> > TblCrew
>> > cCrewID <PK Auto#)
>> > cFName
>> > cLName
>> > cCrewTypeID <Number><linked 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.
>>
>>
>>

Damian · External Since: Nov 09, 2004 Posts: 15

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" <Damian RemoveThis @discussions.microsoft.com> wrote in message
> news:A94149EC-0E6E-44CB-93DF-DCBC435C460A@microsoft.com...
> > 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" <Damian RemoveThis @discussions.microsoft.com> wrote in message
> >> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
> >> > Can't figure out how to do something.
> >> > I have two tables:
> >> >
> >> > TblCrew
> >> > cCrewID <PK Auto#)
> >> > cFName
> >> > cLName
> >> > cCrewTypeID <Number><linked 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.
> >>
> >>
> >>
>
>
>

Gina Whipp · External Since: Sep 25, 2003 Posts: 426

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" <Damian.DeleteThis@discussions.microsoft.com> wrote in message
news:BD69A465-658D-4B5A-A022-54AFE7DC443E@microsoft.com...
> 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" <Damian.DeleteThis@discussions.microsoft.com> wrote in message
>> news:A94149EC-0E6E-44CB-93DF-DCBC435C460A@microsoft.com...
>> > 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" <Damian.DeleteThis@discussions.microsoft.com> wrote in message
>> >> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
>> >> > Can't figure out how to do something.
>> >> > I have two tables:
>> >> >
>> >> > TblCrew
>> >> > cCrewID <PK Auto#)
>> >> > cFName
>> >> > cLName
>> >> > cCrewTypeID <Number><linked 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.
>> >>
>> >>
>> >>
>>
>>
>>

Damian · External Since: Nov 09, 2004 Posts: 15

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" <Damian RemoveThis @discussions.microsoft.com> wrote in message
> news:BD69A465-658D-4B5A-A022-54AFE7DC443E@microsoft.com...
> > 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" <Damian RemoveThis @discussions.microsoft.com> wrote in message
> >> news:A94149EC-0E6E-44CB-93DF-DCBC435C460A@microsoft.com...
> >> > 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" <Damian RemoveThis @discussions.microsoft.com> wrote in message
> >> >> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
> >> >> > Can't figure out how to do something.
> >> >> > I have two tables:
> >> >> >
> >> >> > TblCrew
> >> >> > cCrewID <PK Auto#)
> >> >> > cFName
> >> >> > cLName
> >> >> > cCrewTypeID <Number><linked 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.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Gina Whipp · External Since: Sep 25, 2003 Posts: 426

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" <Damian.DeleteThis@discussions.microsoft.com> wrote in message
news:37961D11-08AF-440D-A6D8-EE7E2B265F92@microsoft.com...
> 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" <Damian.DeleteThis@discussions.microsoft.com> wrote in message
>> news:BD69A465-658D-4B5A-A022-54AFE7DC443E@microsoft.com...
>> > 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" <Damian.DeleteThis@discussions.microsoft.com> wrote in message
>> >> news:A94149EC-0E6E-44CB-93DF-DCBC435C460A@microsoft.com...
>> >> > 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" <Damian.DeleteThis@discussions.microsoft.com> wrote in message
>> >> >> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
>> >> >> > Can't figure out how to do something.
>> >> >> > I have two tables:
>> >> >> >
>> >> >> > TblCrew
>> >> >> > cCrewID <PK Auto#)
>> >> >> > cFName
>> >> >> > cLName
>> >> >> > cCrewTypeID <Number><linked 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.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

Damian · External Since: Nov 09, 2004 Posts: 15

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" <Damian DeleteThis @discussions.microsoft.com> wrote in message
> news:37961D11-08AF-440D-A6D8-EE7E2B265F92@microsoft.com...
> > 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" <Damian DeleteThis @discussions.microsoft.com> wrote in message
> >> news:BD69A465-658D-4B5A-A022-54AFE7DC443E@microsoft.com...
> >> > 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" <Damian DeleteThis @discussions.microsoft.com> wrote in message
> >> >> news:A94149EC-0E6E-44CB-93DF-DCBC435C460A@microsoft.com...
> >> >> > 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" <Damian DeleteThis @discussions.microsoft.com> wrote in message
> >> >> >> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
> >> >> >> > Can't figure out how to do something.
> >> >> >> > I have two tables:
> >> >> >> >
> >> >> >> > TblCrew
> >> >> >> > cCrewID <PK Auto#)
> >> >> >> > cFName
> >> >> >> > cLName
> >> >> >> > cCrewTypeID <Number><linked 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.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Gina Whipp · External Since: Sep 25, 2003 Posts: 426

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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
news:662727F2-DD48-4F11-8A60-7120861FCA98@microsoft.com...
> 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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
>> news:37961D11-08AF-440D-A6D8-EE7E2B265F92@microsoft.com...
>> > 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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
>> >> news:BD69A465-658D-4B5A-A022-54AFE7DC443E@microsoft.com...
>> >> > 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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
>> >> >> news:A94149EC-0E6E-44CB-93DF-DCBC435C460A@microsoft.com...
>> >> >> > 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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
>> >> >> >> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
>> >> >> >> > Can't figure out how to do something.
>> >> >> >> > I have two tables:
>> >> >> >> >
>> >> >> >> > TblCrew
>> >> >> >> > cCrewID <PK Auto#)
>> >> >> >> > cFName
>> >> >> >> > cLName
>> >> >> >> > cCrewTypeID <Number><linked 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.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

Damian · External Since: Nov 09, 2004 Posts: 15

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" <Damian DeleteThis @discussions.microsoft.com> wrote in message
> news:662727F2-DD48-4F11-8A60-7120861FCA98@microsoft.com...
> > 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" <Damian DeleteThis @discussions.microsoft.com> wrote in message
> >> news:37961D11-08AF-440D-A6D8-EE7E2B265F92@microsoft.com...
> >> > 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" <Damian DeleteThis @discussions.microsoft.com> wrote in message
> >> >> news:BD69A465-658D-4B5A-A022-54AFE7DC443E@microsoft.com...
> >> >> > 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" <Damian DeleteThis @discussions.microsoft.com> wrote in message
> >> >> >> news:A94149EC-0E6E-44CB-93DF-DCBC435C460A@microsoft.com...
> >> >> >> > 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" <Damian DeleteThis @discussions.microsoft.com> wrote in message
> >> >> >> >> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
> >> >> >> >> > Can't figure out how to do something.
> >> >> >> >> > I have two tables:
> >> >> >> >> >
> >> >> >> >> > TblCrew
> >> >> >> >> > cCrewID <PK Auto#)
> >> >> >> >> > cFName
> >> >> >> >> > cLName
> >> >> >> >> > cCrewTypeID <Number><linked 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.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Steve · External Since: Aug 04, 2009 Posts: 47

Hello Damian,

You've been at this and you're not getting good help!!

Base your form on TblCrew. Use a combobox for the field cCrewTypeID. With
your form in design view, select the combobox. Open properties and go to the
Data tab. Set the rowsource property to TblCrewType. Still under the Data
tab, set the Bound Column property to 1. Go to the Format tab. Set Column
Count to 2 and Column Width to 0;2. Close properties.

Open your form and try your combobox. It should display ctType but will save
ctCrewTypeID for the selected crew type.

Steve
santus.DeleteThis@penn.com

"Damian" <Damian.DeleteThis@discussions.microsoft.com> wrote in message
news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
> Can't figure out how to do something.
> I have two tables:
>
> TblCrew
> cCrewID <PK Auto#)
> cFName
> cLName
> cCrewTypeID <Number><linked 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.

Damian · External Since: Nov 09, 2004 Posts: 15

Yes thats the way I had it all along. I was seeing ghosts I think.

"Steve" wrote:

> Hello Damian,
>
> You've been at this and you're not getting good help!!
>
> Base your form on TblCrew. Use a combobox for the field cCrewTypeID. With
> your form in design view, select the combobox. Open properties and go to the
> Data tab. Set the rowsource property to TblCrewType. Still under the Data
> tab, set the Bound Column property to 1. Go to the Format tab. Set Column
> Count to 2 and Column Width to 0;2. Close properties.
>
> Open your form and try your combobox. It should display ctType but will save
> ctCrewTypeID for the selected crew type.
>
> Steve
> santus.RemoveThis@penn.com
>
> "Damian" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
> > Can't figure out how to do something.
> > I have two tables:
> >
> > TblCrew
> > cCrewID <PK Auto#)
> > cFName
> > cLName
> > cCrewTypeID <Number><linked 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.
>
>
>

BruceM · External Since: Apr 02, 2009 Posts: 50

You won't help your cause by sniping at others. You can post your own
suggestion if you think the exchange is missing the mark, but you aren't
going to make yourself look bigger by trying to dig a hole under somebody
else. Quite the contrary: you are the one on his knees clawing at the
dirt.

"Steve" <notmyemail.TakeThisOut@address.com> wrote in message
news:dsGdndAog8stweXXnZ2dnUVZ_qCdnZ2d@earthlink.com...
> Hello Damian,
>
> You've been at this and you're not getting good help!!
>
> Base your form on TblCrew. Use a combobox for the field cCrewTypeID. With
> your form in design view, select the combobox. Open properties and go to
> the Data tab. Set the rowsource property to TblCrewType. Still under the
> Data tab, set the Bound Column property to 1. Go to the Format tab. Set
> Column Count to 2 and Column Width to 0;2. Close properties.
>
> Open your form and try your combobox. It should display ctType but will
> save ctCrewTypeID for the selected crew type.
>
> Steve
> santus.TakeThisOut@penn.com
>
> "Damian" <Damian.TakeThisOut@discussions.microsoft.com> wrote in message
> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
>> Can't figure out how to do something.
>> I have two tables:
>>
>> TblCrew
>> cCrewID <PK Auto#)
>> cFName
>> cLName
>> cCrewTypeID <Number><linked 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.
>
>

Gina Whipp · External Since: Sep 25, 2003 Posts: 426

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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
news:8857B272-1BA9-411C-B579-66F6B504CDB4@microsoft.com...
> 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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
>> news:662727F2-DD48-4F11-8A60-7120861FCA98@microsoft.com...
>> > 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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
>> >> news:37961D11-08AF-440D-A6D8-EE7E2B265F92@microsoft.com...
>> >> > 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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
>> >> >> news:BD69A465-658D-4B5A-A022-54AFE7DC443E@microsoft.com...
>> >> >> > 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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
>> >> >> >> news:A94149EC-0E6E-44CB-93DF-DCBC435C460A@microsoft.com...
>> >> >> >> > 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" <Damian.RemoveThis@discussions.microsoft.com> wrote in message
>> >> >> >> >> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
>> >> >> >> >> > Can't figure out how to do something.
>> >> >> >> >> > I have two tables:
>> >> >> >> >> >
>> >> >> >> >> > TblCrew
>> >> >> >> >> > cCrewID <PK Auto#)
>> >> >> >> >> > cFName
>> >> >> >> >> > cLName
>> >> >> >> >> > cCrewTypeID <Number><linked 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.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

Gina Whipp · External Since: Sep 25, 2003 Posts: 426

Steve...

Once again you show your TRUE colors in the newsgroup you constantly post
for help...

--
Gina Whipp

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

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

"Steve" <notmyemail.TakeThisOut@address.com> wrote in message
news:dsGdndAog8stweXXnZ2dnUVZ_qCdnZ2d@earthlink.com...
> Hello Damian,
>
> You've been at this and you're not getting good help!!
>
> Base your form on TblCrew. Use a combobox for the field cCrewTypeID. With
> your form in design view, select the combobox. Open properties and go to
> the Data tab. Set the rowsource property to TblCrewType. Still under the
> Data tab, set the Bound Column property to 1. Go to the Format tab. Set
> Column Count to 2 and Column Width to 0;2. Close properties.
>
> Open your form and try your combobox. It should display ctType but will
> save ctCrewTypeID for the selected crew type.
>
> Steve
> santus.TakeThisOut@penn.com
>
> "Damian" <Damian.TakeThisOut@discussions.microsoft.com> wrote in message
> news:A8497EA8-BC6B-4ADF-BAC6-C658BE2485B3@microsoft.com...
>> Can't figure out how to do something.
>> I have two tables:
>>
>> TblCrew
>> cCrewID <PK Auto#)
>> cFName
>> cLName
>> cCrewTypeID <Number><linked 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.
>
>

Keith Wilby · External Since: Apr 25, 2006 Posts: 216

"Steve" <notmyemail.RemoveThis@address.com> wrote in message
news:dsGdndAog8stweXXnZ2dnUVZ_qCdnZ2d@earthlink.com...
> You've been at this and you're not getting good help!!
>

Such arrogance from someone of such questionable ability.

http://home.tiscali.nl/arracom/whoissteve.html