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

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

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