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 not displaying
I have a combo box whos item list is populated via a parameter query. The
query parameter is obtained from another control on the form. The query is a lookup which maps an ID number from the table to a text colum. The combobox is formatted for two columns with the second text column visible. I have existing records in the table. When I navigate through the records, the field value in the table is not displayed until I click in the control. What is happening and how do I fix it? It was working by putting a hidden text box whose control source is the value of the combo box. (via a suggestion from this forum, I believe). Something changed with recent development and I don't know what caused it to break. Hidden box control source: =[ProgramTitle Box].Column(1) Thanks in advance, John |
#2
|
|||
|
|||
Combo Box not displaying
It's difficult to know "What's happenning" but perhaps you could investigate
it by a. making the hidden text box visible for the moment so you8 can see what's in it b putting debug.print me.mycomboname.rowsource in the combos onclick event then having a look at what the rowsource is when you click the combo. an alternative to b. is to use a message box msgbox me.mycombo.rowsource I prefer the first option because you can copy and paste the row source from debug if you want to. Jim Bunton "DocBrown" wrote in message ... I have a combo box whos item list is populated via a parameter query. The query parameter is obtained from another control on the form. The query is a lookup which maps an ID number from the table to a text colum. The combobox is formatted for two columns with the second text column visible. I have existing records in the table. When I navigate through the records, the field value in the table is not displayed until I click in the control. What is happening and how do I fix it? It was working by putting a hidden text box whose control source is the value of the combo box. (via a suggestion from this forum, I believe). Something changed with recent development and I don't know what caused it to break. Hidden box control source: =[ProgramTitle Box].Column(1) Thanks in advance, John |
#3
|
|||
|
|||
Combo Box not displaying
Are you using Access 2003 with SP3 installed? If so take a look at this hot
fix, I had the exact same issue. It would work in A2K and A2007 but not in A2003 until I applied the following patch, see below: http://support. microsoft. com/default. aspx/kb/945674 http://support. microsoft. com/default. aspx/kb/945280/ after applying the hot fix all was well! Let me know how you made out! Norm |
Thread Tools | |
Display Modes | |
|
|