Help with ComboBox

[Psyclone]

I have a form that is working perfectly except for one simple function. Currently, my form has a ComboBox that has 96 different "Player Names" in it from a query. When you select a "Player Name" from the ComboBox, the rest of the form will display that player's statistics (other fields from the query). There are no other controls on the form, just a whole bunch of TextBoxes used for display purposes.



My only problem is that I can only cycle through the ComboBox using my mouse wheel or arrow keys. I can't click on any of the rows in the ComboBox and I can't type in a person's name into the ComboBox. The only way to select a name from the ComboBox is with the mouse wheel or arrow keys. Other than that, everything works perfectly.

I've been driving myself nuts trying everything and reading everything online about ComboBox properties. It seems like it's probably something really simple, but I'm totally stuck. Any help would be appreciated.

[jzwp11]

Are there any macros or VBA procedures tied to the form that would impact the combo box?

[Psyclone]

No. No macros or VBA.

[jzwp11]

You must have some code in order to do this:

When you select a "Player Name" from the ComboBox, the rest of the form will display that player's statistics (other fields from the query).

[Psyclone]

I just used the wizard to tie the combobox to the record selection. I dont see any code that was created.

[jzwp11]

Do the controls (control source) on your form reference the combo box something like this:

=comboboxname.column(x)


What happens if you rebuild the combo box and form?


By any chance can you post a copy of your database with any sensitive data removed?

[Psyclone]

I think the problem is that I'm using the wizard and selecting the option "Find a record on my form based on the value I selected in my ComboBox."

I don't see any code that this is generating though.

[jzwp11]

There probably is some code in the after update event of the combo box, but you still should be able to select an item from the combo box. That part is still strange.