Error with Combobox and Row Source

A

accesskastle

Hi. I developed an application in Access 2000 and moved to 2003, and I am
having trouble with comboboxes now. The combobox rowsource references a
simple SQL query with two tables linked via primary key. The query, when I
open it from the Database Window, displays correctly. However, when I view
it through a drop-down list on a form, the data in the first column fails to
appear, even though the Column Header does. Has anyone seen this or know how
to stop it?

AK
 
B

banem2

Hi.  I developed an application in Access 2000 and moved to 2003, and I am
having trouble with comboboxes now.  The combobox rowsource references a
simple SQL query with two tables linked via primary key.  The query, when I
open it from the Database Window, displays correctly.  However, when I view
it through a drop-down list on a form, the data in the first column fails to
appear, even though the Column Header does.  Has anyone seen this or know how
to stop it?

AK
Click to expand...

Looks like a bug with SP3. Have a look for hotfix of this issue:
http://support.microsoft.com/kb/945280

Regards,
Branislav Mihaljev, Microsoft Access MVP
 
Top