By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,775 Members | 1,399 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,775 IT Pros & Developers. It's quick & easy.

AC07 combo boxes--is this a bug?

P: n/a
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. tblArticleKeyword
a. artiID, number, PK
b. keywID, number, PK

Step 2: Relationships

tblArticle.artiID to tblArticleKeyword.artiID
tblKeyword.keywID to tblArticleKeyword.keywID
- enable integrity, cascading updates and deletes.

Step 3: Create a form

1. Record Source:
a. SELECT [tblArticleKeyword].[artiID], tblArticleKeyword.[keywID]
FROM tblArticleKeyword;
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.

Jun 13 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Jun 12, 11:23 pm, John Kreps <soundnee...@gmail.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. tblArticleKeyword
a. artiID, number, PK
b. keywID, number, PK

Step 2: Relationships

tblArticle.artiID to tblArticleKeyword.artiID
tblKeyword.keywID to tblArticleKeyword.keywID
- enable integrity, cascading updates and deletes.

Step 3: Create a form

1. Record Source:
a. SELECT [tblArticleKeyword].[artiID], tblArticleKeyword.[keywID]
FROM tblArticleKeyword;
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.keywName is really tblKeyword.KeywDescr (ie, same thing)

Jun 13 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.