[AccessD] No Current Record when populating additem combo???

Dan Waters df.waters at outlook.com
Sat Aug 1 12:29:23 CDT 2015


Hi Bill,

Column.count is zero-based.

Try   For i = 0 To col.Count - 1

Hope that's it!
Dan


Sent from my Windows Phone
________________________________
From: Bill Benson<mailto:bensonforums at gmail.com>
Sent: ‎8/‎1/‎2015 10:28
To: Access Developers discussion and problem solving<mailto:accessd at databaseadvisors.com>
Subject: [AccessD] No Current Record when populating additem combo???

I have a cbo whose rowsourcetype is value list.
The problem is occurring on Form_Load, where I call a routine to populate
the cbo.
There is no controlsource, so this cbo is not tied to any field in the
recordsource.

I have stored some values that can go into the cbo (strings) in a
collection.

At the time I am having this problem there is only one item in the
collection and the cbo is empty..

My code is failing here:

For i = 1 To col.Count
    cboSessionUser.AddItem col(i)
Next

The error message is Runtime Error 3021 "No Current Record".

This doesn't make any sense to me.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list