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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box - not in list 2
Combo box help 1
1 combo box changes per 2 other combo boxes 3
Combo Boxes/Queries 1
Combo Box 1
Access Control on subform / combo box requesting parameter 0
Combo box / Query 1
Conditional Combo Box 3

Back
Top