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

Jumat, 10 Mei 2013

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

Thanks John,

That gives me a head start on changing the Combo
source #:o)

Regards, Clive.

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> 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
>