[AccessD] Combos with Tens of Thousands of Records

[Stuart McLachlan]

FWIW, I've just created a new database, built a Postcods table, created a form, placed a 
combobox on it and pasted the code from steps 1,2 and 3.  It works fine.


On 23 Jun 2021 at 16:48, Stuart McLachlan wrote:

> In that case, can you post the actual function as you have it entered.
> 
> 
> On 23 Jun 2021 at 9:38, Kostas Konstantinidis wrote:
> 
> > Hi David
> > I have already tried it... doesn't work
> > Thank's
> > 
> > -----Original Message-----
> > From: AccessD
> > <accessd-bounces+kost36=gmail.com at databaseadvisors.com> On Behalf Of
> > David Emerson Sent: Wednesday, June 23, 2021 9:29 AM To: 'Access
> > Developers discussion and problem solving'
> > <accessd at databaseadvisors.com> Subject: Re: [AccessD] Combos with
> > Tens of Thousands of Records
> > 
> > Without looking at the code in detail, try replacing Me. With Me!
> > 
> > Regards
> > 
> > David Emerson
> > Dalyn Software Ltd
> > Wellington, New Zealand
> > 
> > 
> > 
> > -----Original Message-----
> > From: AccessD
> > <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On
> > Behalf Of Kostas Konstantinidis Sent: Wednesday, 23 June 2021 5:34
> > pm To: 'Access Developers discussion and problem solving'
> > <accessd at databaseadvisors.com> Subject: [AccessD] Combos with Tens
> > of Thousands of Records
> > 
> > Hi all,
> > I use a combo box with more than 85.000 records (names) and I am
> > trying Allen Browne's solution at http://allenbrowne.com/ser-32.html
> > I followed his instructions step by step but the code stops on the
> > function's point
> >             Me.Suburb.RowSource = "SELECT Suburb, State, Postcode
> >             FROM
> > Postcodes WHERE (False);"
> >             sSuburbStub = ""
> >  With the error "Invalid use of Me keybord"
> > Any idea?
> > Thank's all
> > /kostas 
> > 
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>