[AccessD] Combos with Tens of Thousands of Records

[David Emerson]

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