Combo Box Empty?

[djclinton15]

Hi, I use Combo Boxes quite often in my Forms & usually haveno troubles. I have 2-forms from 1-table in which I created Como Box froma query. If I start to type in the first few letters it will fill in therest of the test. I.E., I want to input, "ARSPPLY." If Istart typing in, "ARS" the rest "PPLY" fills in/appears;typically. However, when I pull down the Combo Box to see what's listedit's empty/showing nothing. Oddly enough, I created other similar ComboBoxes in other forms (using the same query. Why am I getting a blank listwhen Ii pull down the Combo Box from a query?

Anyadvice/suggestions will be greatly appreciated! Thanks in advanced.

[Micron]

Oddly enough, I created other similar ComboBoxes in other forms (using the same query.

I can only guess that you mean they work elsewhere.
If you're sure the design is correct (e.g. the column you expect to see is not set to 0" width or the column/field counts don't match) then post the sql for the combo row source. There could be an issue with your table/field names, such as "tbl-Main". What is tbl minus Main? Access doesn't know either.
Is the query against a local table or is it against a linked spreadsheet or csv file?

[Missinglinq]

the column you expect to see is not set to 0" width

or

the column/field counts don't match

Micron has listed the most common villains in this type of scenario...barring them, the Combobox Control itself could be corrupted. Although we usually think of Forms or entire Databases when we speak of corruption, individual Controls, such as Comboboxes, can and do become corrupted. The test and the fix are one and the same; deleting the Control then re-creating it! If it was corrupt, you've verified the fact and solved the problem! If not, you've only lost a minute or two!

Linq ;0)>