[AccessD] Combos with Tens of Thousands of Records

[Stuart McLachlan]

Yep.

Bang operator references objects (collection members)
Dot operator references  an object's properties/methods. 

VBA used to be mch more forgiving about this in earlier versions.

On 23 Jun 2021 at 18:29, David Emerson wrote:

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