Form Combo Box blank in ver 2003 - created in 2007 as 2002-2003

[CDS]

I am new to Access and have Vista 64 with Access 2007 and XP with 2003. I
created a database in the 2007 ver as a 2002-2003 and when I opened it in
2003 there were no error messages but a major combo box drop down is blank.
I went back to the 2007 ver with the same file and it opened fine. There are
appox. 80 small records in the Lookup Table that is not showing. Any ideas?
Thanks.

 

[John Spencer]

If you have SP3 installed for Access 2003, there is a bug that can cause this
behavior. And there is a hotfix for it. Check Allen Browne's site

http://allenbrowne.com/bug-Access2003SP3.html

You might check the properties of the combobox and make sure the column count
is equal to the number of columns being passed by the source. I have found
that sometimes this works to fix the problem.


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[CDS]

John,
I do have SP3, so I will start with the fix and check the columns.
Many thanks for the advise. I had no idea where to start.
CDS