ACCESS FEED: RE: [MS_AccessPros] Show the records in a ComboBox once 'n' characters have been typed

Kamis, 09 Mei 2013

RE: [MS_AccessPros] Show the records in a ComboBox once 'n' characters have been typed

Clive-

I would have to dig around to find the exact example, but the technique is:

1) Use a Row Source (SQL) with WHERE 1=2 to get no rows to start with.

2) In On Change, check the length of Me.cmbMyCombo.text, and if it is 3 or
more, change the Row Source to:

SELECT ... FROM .... WHERE DisplayField LIKE Me.cmbMyCombo.text & "*"

You have to use the Text property to see what the user is typing.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Clive
Sent: Thursday, May 09, 2013 11:42 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Show the records in a ComboBox once 'n' characters
have been typed

Hi all,

I would like to show a subset of several thousand records in a ComboBox
after, say 4 characters, have been entered.

I saw this mentioned here some years ago but can't remember the details.

I would appreciate some help on this.

Regards, Clive.

------------------------------------

Yahoo! Groups Links