AC07 combo boxes--is this a bug?

[John Kreps]

I've tried to get combo boxes to work with Access 2007 for days now
without success. What I can't get to work is the autocomplete. I've
got three simple tables and one form with two controls. Initially, the
autocomplete works. However, after exiting and restarting access, the
autocomplete stops. If I type in a valid record/entry, access says
item not in list. But, I can select the same record/entry in the drop
down without getting an error.

I've laid out five steps that will reproduce this behavior---step 5 is
where the autocomplete stops working. ANY HELP is so appreciated! I've
spent days trying to understand why this is happening. It seems so
simple...I've been using access for a few years now and will feel a
bit dimmed if someone can quickly solve this!
To reproduce this behavior:

Step 1: Create three tables.

1. tblArticle
a. artiID, autonumber, PK
b. artiTitle, text
2. tblKeyword
a. keywID, autonumber, PK
b. keywDescr, text
3. tblArticleKeywo rd
a. artiID, number, PK
b. keywID, number, PK

Step 2: Relationships

tblArticle.arti ID to tblArticleKeywo rd.artiID
tblKeyword.keyw ID to tblArticleKeywo rd.keywID
- enable integrity, cascading updates and deletes.

Step 3: Create a form

1. Record Source:
a. SELECT [tblArticleKeywo rd].[artiID], tblArticleKeywo rd.[keywID]
FROM tblArticleKeywo rd;
2. Text control
a. Control Source: artiID
3. Combo control
a. Control Source: keywID
b. Row Source: SELECT [tblKeyword].[keywID], [tblKeyword].[keywName]
FROM tblKeyword;
c. Column count is 2, bound to column 1, width is 0";1"

Step 4: Populate tables

a. tblArticle- add three dummy records
b. tblKeyword- add three dummy records

Step 5: Test form

a. Initially, the combo control will autocomplete.
b. Exit access and restart.
c. Test combo again---it fails to autocomplete.

[John Kreps]

On Jun 12, 11:23 pm, John Kreps <soundnee...@gm ail.comwrote:

I've tried to get combo boxes to work with Access 2007 for days now
without success. What I can't get to work is the autocomplete. I've
got three simple tables and one form with two controls. Initially, the
autocomplete works. However, after exiting and restarting access, the
autocomplete stops. If I type in a valid record/entry, access says
item not in list. But, I can select the same record/entry in the drop
down without getting an error.

I've laid out five steps that will reproduce this behavior---step 5 is
where the autocomplete stops working. ANY HELP is so appreciated! I've
spent days trying to understand why this is happening. It seems so
simple...I've been using access for a few years now and will feel a
bit dimmed if someone can quickly solve this!

To reproduce this behavior:

Step 1: Create three tables.

1. tblArticle
a. artiID, autonumber, PK
b. artiTitle, text
2. tblKeyword
a. keywID, autonumber, PK
b. keywDescr, text
3. tblArticleKeywo rd
a. artiID, number, PK
b. keywID, number, PK

Step 2: Relationships

tblArticle.arti ID to tblArticleKeywo rd.artiID
tblKeyword.keyw ID to tblArticleKeywo rd.keywID
- enable integrity, cascading updates and deletes.

Step 3: Create a form

1. Record Source:
a. SELECT [tblArticleKeywo rd].[artiID], tblArticleKeywo rd.[keywID]
FROM tblArticleKeywo rd;
2. Text control
a. Control Source: artiID
3. Combo control
a. Control Source: keywID
b. Row Source: SELECT [tblKeyword].[keywID], [tblKeyword].[keywName]
FROM tblKeyword;
c. Column count is 2, bound to column 1, width is 0";1"

Step 4: Populate tables

a. tblArticle- add three dummy records
b. tblKeyword- add three dummy records

Step 5: Test form

a. Initially, the combo control will autocomplete.
b. Exit access and restart.
c. Test combo again---it fails to autocomplete.

3.b tblKeyword.keyw Name is really tblKeyword.Keyw Descr (ie, same thing)