[MSAccessProfessionals] Combo Box

I have a combo box on a form that looks up my customers.

 

As I type, the combo box sorts the names and when I finally get the correct name I hit enter and the form move to the correct record…

 

Until today.  Now when I type the combo box does nothing most of the time.  When I type into the box it does not sort…with the exception of very few customers that have names that start with letters that are in the early part of the alphabet.

If I click the drop down button and type in the box, it sort correctly and will select the correct record. 

 

I have deleted and re-created the combo box multiple times.  Each time it acts the same.

I have even gone copied a combo box off of an old form that worked correctly, and it still acts the same. 

 

I even pulled a complete form from an old backup database and the Combo box still does not work.

 

The event is a Embedded Macro in AFTER UPDATE

Here is the Row Source  ..   SELECT [q_MainCustomerInput].[OrganizationName], [q_MainCustomerInput].[CustomersID] FROM q_MainCustomerInput;

 

Any thoughts?

 

Bill

 

Bill Singer

Bill.Singer@at-group.net