Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

combobox autoexpand strange behavior

Posted on 2006-11-17
1
Medium Priority
?
369 Views
Last Modified: 2008-02-01
I have a combobox whose rowsource is: select last & ", " & first from mailingList, and autoexpand is True.
I have a person in the mailingList with last = "I" and first = "P".
When I type 'i' in the combobox I, P appears (as expected), but then the insertion point jumps to just past the I and autoexpand does not respond as expected to entry of a 2nd last name letter. Any thoughts?
0
Comment
Question by:ramrom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 500 total points
ID: 17970495
Try using the keyword "Distinct" as discussed in this link:

         select DISTINCT last & ", " & first from mailingList

             http://support.microsoft.com/kb/824189
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question