Re: AC07 combo boxes--is this a bug?

On Jun 12, 11:23 pm, John Kreps <soundnee...@xxxxxxxxx> wrote:
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)

.

Relevant Pages

  • AC07 combo boxes--is this a bug?
    ... What I can't get to work is the autocomplete. ... I can select the same record/entry in the drop ... Control Source: artiID ...
    (comp.databases.ms-access)
  • Re: Autocomplete textbox with dynamic datasource
    ... Sheng Jiang ... Microsoft MVP in VC++ ... I tried to use the AutoComplete COM control based upon ... Unfortunately the control doesn't 'ask' for an updated list of items as I ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Autocomplete textbox with dynamic datasource
    ... Sheng Jiang ... Microsoft MVP in VC++ ... I tried to use the AutoComplete COM control based upon ... Unfortunately the control doesn't 'ask' for an updated list of items as I ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: When to use "." and when to use "!"
    ... someone else is that errors are picked up at compile time. ... The autocomplete issue is a red herring, ... around your control that behaves like a property of the form. ... syntax for controls on forms can very rarely lead to ...
    (comp.databases.ms-access)
  • Combobox with autocomplete
    ... I like the control "Combobox" with the Autocomplete property set to ... For those of you unfamiliar with it, the control consists of a ... I tried to work around it, by capturing the KeyDown event, but ...
    (microsoft.public.dotnet.languages.csharp)
Loading