[AccessD] Combos with Tens of Thousands of Records

[Stuart McLachlan]

Are you sure that it is is  in the Form's module and not a standard module?
If it is in a standard module you will get that error (There is no "Me". in a standard module!)

> > > -----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
> > 
> 
> 
> -- 
> 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
>