?
Solved

combobox autoexpand strange behavior

Posted on 2006-11-17
1
Medium Priority
?
360 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

765 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