If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a Form
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. |
#2
|
|||
|
|||
Creating a Form
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. |
#3
|
|||
|
|||
Creating a Form
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. |
#4
|
|||
|
|||
Creating a Form
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. |
#5
|
|||
|
|||
Creating a Form
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. |
#6
|
|||
|
|||
Creating a Form
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. |
#7
|
|||
|
|||
Creating a Form
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. |
#8
|
|||
|
|||
Creating a Form
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. |
#9
|
|||
|
|||
Creating a Form
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. |
#10
|
|||
|
|||
Creating a Form
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. |
|
Thread Tools | |
Display Modes | |
|
|