Combo Box not displaying

[DocBrown]

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

 

[Jim Bunton]

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

 

[norm]

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