Invisible Results in Combo Box 1

[joebb3]

This has been asked before with no resolution... I pasted the question below because the user did a good job of explaining it.

-----

I just created a new form that used a query to populate a drop down list box.

The bizzare thing is that if you click on the box, nothing shows up in the list, but if you select a line (blank) and click on it, the value that would show up appears in the top of the dropdown box.

----

Here is the weird part. Its a 2 column query, Month and a sort order...

Month Sort
OCT 1
NOV 2
...
SEP 12

If I show BOTH columns, the SORT column is VISIBLE (you can see the numbers) but the actual months are invisible as stated above.

I have 2 other combo boxes on the same form that work perfectly and have the exact same properties! The only differences are:

Name: MONTH
Row Source: MONTH QUERY (Contains above data.)

I'm NOT new to Access BY FAR and lets face it, an unbound combo box with a Table/Query Row Source Type off of a static query isn't rocket science, but this has go me stumped!!!

Is it an issue of a protected word (month) or something unusual like that?

 

[dhookom]

Hi Joe,
Congrats on your learning and success. Many of us started using Access and other programs with little or no programming experience. Some of us did this way before there was on-line support (or even on-line ;-).

Anyone who has benefitted from Tek-Tips should consider paying it forward or contributing to the Tek-Tips site.

Duane
Hook'D on Access
MS Access MVP