Combo Boxes won't auto-full...?

[djclinton15]

I hope that my thread makes some sense to someone. When I used Forms with Combo Boxes as I started typing an item it would automatically come up/fill-in. I had to recreate a similar Form with similar Combo Box, but now when I start to type/input an item I need to type in the full item name. I have abbreviations for all of my items which is hard to remember -- can cause errors. I'll try to give an example:




I want to type in, "FTWDMC." I use to just start to type in, "FT" & then the rest would appear/auto-full (as a suggestion). Except, on my new recreated Form it's not working as such. Is there some trick/setting that I'm missing? I would hope not to need to recreate another Form, but...


Any suggestions will be greatly appreciated. Thanks in advance!

[Bob Fitz]

What is the Row Source property of each combo box.

[djclinton15]

Thanks for responding to my thread. The Row Source Property is from a query I specifically created for this Combo Box, but I don't know if that's what you're requesting? The Row Source Table is, Table/Query; I think that's correct.

[ssanfu]

I always set these properties for combo boxes (at a minimum):
Property data tab-
Limit to List - Yes
Allow value list edits - No
Autoexpand - YES

Click in the Autoexpand property, then press the F1 key for more info.

[djclinton15]

Thanks, but no luck.

[June7]

Provide the SQL statement of the query used as RowSource.

If you want to provide db for analysis, follow instructions at bottom of my post.

[djclinton15]

Hi June, I'm djclnt, but have been away (nursing home) so unlikely you'll remember me.

SELECT Music_Entriesqry.*, Music_Entriesqry.MLDate
FROM Music_Entriesqry
WHERE (((Format$([Music_Entriesqry].[MLDate],"Short Date")) Like "*2015"))
ORDER BY Music_Entriesqry.MLDate, Music_Entriesqry.mlgID;

* the db is just too large to send even in WinZip

[June7]

So what is in the combobox RowSource property - query name or this SQL statement?

Why are you using * to pull every field?

What order are the fields in?

What are settings of other properties of combobox:

ControlSource (is this UNBOUND?)
BoundColumn
ColumnCount
ColumnWidths

[ssanfu]

Hi djclnt, I do remember you. Good to see you back.

I also wonder about the number of fields - how many fields are in the query Music_Entriesqry ?

Also, why are you converting a date to a string to do the filtering?
If "MLDate" is a date/time type, you might try

SELECT Music_Entriesqry.*, Music_Entriesqry.MLDate
FROM Music_Entriesqry
WHERE Year([Music_Entriesqry].[MLDate]) = 2015
ORDER BY Music_Entriesqry.MLDate, Music_Entriesqry.mlgID;

[djclinton15]

June, I was able to attached the db. The Form which I'm speaking of ought to open automatically. If not, it's named, 2015_Music_Entries​

[djclinton15]

I got it guys, thanks to all!

[ssanfu]

Did a lot of searching and found that the first displayed field will (should) autoexpand.
Just change the order of the first two fields in the combo box query; ArtistID should be the first field.