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. |
#8
|
|||
|
|||
Creating a Form
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" wrote in message m... 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 "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
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 "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
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" wrote in message m... 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 "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 | |
|
|