Combo Box quirk

  • Thread starter Thread starter Jerry Crosby
  • Start date Start date
J

Jerry Crosby

I have two combo boxes on a form. One "pulls" its data from an existing
query, the other from an "on the fly" query. Beyond that, settings are
identical on both as far as I can see.

On one of them, as I begin typing it expands out to show the fields in the
table. So, if I enter "s," "Saturday" will appear (first word in the table
beginning with S). Then, if I continue and type "u" the Saturday will
change to Sunday (another word in the table). This is the way I want it to
respond.

However, in the other combo box, typing the initial "S" will bring up
"Saturday," but it stops there. Continuing with a "u" gives me "Suaturday".

How do I fix the second scenario to act like the first?
 
In the second combo box, if you type S and Saturday shows in the box, and
then you continue typing with U, it inserts the u into the word Saturday?

Both combo boxes have AutoExpand set to Yes? What are the queries for both
row sources? What are the bound columns for both?
 
Back
Top