How to change contents of combo box?

[LAS]

I have this code in a script. gs_sql, when cut and pasted to a query,
returns the expected rows. But after this code is executed, the contents of
the combo box are empty. What am I doing wrong?

cboStudent_ID.RowSource = gs_sql
cboStudent_ID.Requery

 

[Douglas J. Steele]

When you say "empty", do you mean that there appears to be data in the combo
box (i.e.: the right-hand scroll bar is active), but you cannot actually see
the values?

What version of Access are you using? What's the actual content of gs_sql?
(if you're using Access 2003 and you've got Format functions in your SQL,
you may need to apply the Access 2003 post-Service Pack 3 hotfix
http://support.microsoft.com/kb/945674 )

 

[LAS]

No, I mean that only one row's worth of white space appears below the empty
input field instead of the normal row per item. No arrow.

 

[LAS]

I have found the problem. It's a "DUH" thing. I was selecting * instead of
the exact columns I needed for the dropdown.