Combo Box Auto Expand does not work!

[C. Sharp]

I have a "Master"table that various fields, i.e. Salutation. In my Master
table I created a field called Salutation. Made it a Combo Box - Table/Query
and it is to open TBL_Salutation for a list of drop downs. Once I save and
open the Master tabel to enter data the drop down list is there BUT if I
enter "d" it does not auto expand to Dr. It just sits there but if I select
the drop down list I see my options from the TBL_Salutation. This worked in
a previous version of my database so I renamed the current Master Table_BAK
and imported the MASTER table from a previous DB. And voila! my auto
expand worked UNTIL I excited the DB and opened it back up. So I thought it
might have something to do with teh compact on close. So I removed that
feature and all the records in case my data was corrupt. Re-imported the
working Master table...Voila it worked again UNTIL I closed and reopened the
DB. Why does this work until I close the DB and reopen it??? This is very
frustrating. I even tried re-creating all the fields that were drops downs
and re-attaching them to their reqpctive control source - tables. NOTHING
seems to work. Any suggestions???? Thanks in advance.

 

[Jeff Boyce]

It sounds like you are describing a field in a table that you've used the
"lookup" data type to create.

There is considerable consensus AGAINST using this data type -- check this
newsgroup.

If you are working directly in the tables, this would be a good time to
stop! Access tables may look like spreadsheets, but they aren't. Access
forms are designed to display data, and provide a much richer environment
for things like controlling what comboboxes do...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP