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
|
|||
|
|||
Combo Box question
A coworker is developing a access application which has a combo box on a form
that is bound to a table with two columns (text desc, number id). When you create a new record you can select the text desc from the combo box with no problems. She then saves the record and closes the form. Now when she tries to reopen the form and select an existing record nothing is showing up in the combo box, though the value is stored in the table. She would like to know what can be done so the combo box will show the value from the first column(text desc) for an existing record. Any help would be greatly appreciated. Dan |
#2
|
|||
|
|||
Combo Box question
Are there controls on the form that are bound to the text desc and number id
fields? Is the combo box unbound? Does the combo box have two columns - one for each field? What is the order of the columns in the combo? Which column of the combo is the bound column? -- Dave Hargis, Microsoft Access MVP "Dan" wrote: A coworker is developing a access application which has a combo box on a form that is bound to a table with two columns (text desc, number id). When you create a new record you can select the text desc from the combo box with no problems. She then saves the record and closes the form. Now when she tries to reopen the form and select an existing record nothing is showing up in the combo box, though the value is stored in the table. She would like to know what can be done so the combo box will show the value from the first column(text desc) for an existing record. Any help would be greatly appreciated. Dan |
#3
|
|||
|
|||
Combo Box question
combo box is bound to a number field. Second field is bound field which is
number also. But first field is the text that is displayed when selecting the value. I also want to see text value for saved records. "Klatuu" wrote: Are there controls on the form that are bound to the text desc and number id fields? Is the combo box unbound? Does the combo box have two columns - one for each field? What is the order of the columns in the combo? Which column of the combo is the bound column? -- Dave Hargis, Microsoft Access MVP "Dan" wrote: A coworker is developing a access application which has a combo box on a form that is bound to a table with two columns (text desc, number id). When you create a new record you can select the text desc from the combo box with no problems. She then saves the record and closes the form. Now when she tries to reopen the form and select an existing record nothing is showing up in the combo box, though the value is stored in the table. She would like to know what can be done so the combo box will show the value from the first column(text desc) for an existing record. Any help would be greatly appreciated. Dan |
#4
|
|||
|
|||
Combo Box question
Sorry, Dan, I got a bit lost in this.
Please tell me the names of the field in the table. The names of the controls on the form. Show which table field is bound to which form control. Post the row source for the combo box. Which column in the combo box is the bound column? If you can provide that, I think I can work out the problem. -- Dave Hargis, Microsoft Access MVP "Dan" wrote: combo box is bound to a number field. Second field is bound field which is number also. But first field is the text that is displayed when selecting the value. I also want to see text value for saved records. "Klatuu" wrote: Are there controls on the form that are bound to the text desc and number id fields? Is the combo box unbound? Does the combo box have two columns - one for each field? What is the order of the columns in the combo? Which column of the combo is the bound column? -- Dave Hargis, Microsoft Access MVP "Dan" wrote: A coworker is developing a access application which has a combo box on a form that is bound to a table with two columns (text desc, number id). When you create a new record you can select the text desc from the combo box with no problems. She then saves the record and closes the form. Now when she tries to reopen the form and select an existing record nothing is showing up in the combo box, though the value is stored in the table. She would like to know what can be done so the combo box will show the value from the first column(text desc) for an existing record. Any help would be greatly appreciated. Dan |
#5
|
|||
|
|||
Combo Box question
Dave,
Thanks for the help. While posting the information here she found another solution to the problem. I don't know all the details. Thanks again Dan "Klatuu" wrote: Sorry, Dan, I got a bit lost in this. Please tell me the names of the field in the table. The names of the controls on the form. Show which table field is bound to which form control. Post the row source for the combo box. Which column in the combo box is the bound column? If you can provide that, I think I can work out the problem. -- Dave Hargis, Microsoft Access MVP "Dan" wrote: combo box is bound to a number field. Second field is bound field which is number also. But first field is the text that is displayed when selecting the value. I also want to see text value for saved records. "Klatuu" wrote: Are there controls on the form that are bound to the text desc and number id fields? Is the combo box unbound? Does the combo box have two columns - one for each field? What is the order of the columns in the combo? Which column of the combo is the bound column? -- Dave Hargis, Microsoft Access MVP "Dan" wrote: A coworker is developing a access application which has a combo box on a form that is bound to a table with two columns (text desc, number id). When you create a new record you can select the text desc from the combo box with no problems. She then saves the record and closes the form. Now when she tries to reopen the form and select an existing record nothing is showing up in the combo box, though the value is stored in the table. She would like to know what can be done so the combo box will show the value from the first column(text desc) for an existing record. Any help would be greatly appreciated. Dan |
Thread Tools | |
Display Modes | |
|
|