Christopher Jeris
cjeris at fas.harvard.edu
Tue Jun 12 14:55:00 CDT 2007
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hale, Jim wrote: > If rs.BOF and rs.EOF then This doesn't change the problem, which occurs in the case when rs.BOF (or rs.BOF And rs.EOF) is False. Thanks for the tip though! Steve Schapel wrote: > ... I am also unfamiliar with the concept of: > Me!List0.Recordset > Should that be?... > Me!List0.RowSource I would have used .RowSource, but in the actual location where this construct is used, I need to supply parameters to the query that populates the listbox, and those parameters are determined by other settings. I didn't see a way to do that with the .RowSource property, which seems to take only the name of a table or query, or else a statically determined list of values. However, this problem also occurs in other listboxes in the same project whose row sources are set by other means. Sometimes it works, but more often any construct of the form Me!ListboxName.Selected(0) = True freezes the form. Is this just a totally bizarre and novel failure? thanks, Chris Jeris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGbvoU5ICCNV0oGWARAsPNAJwLHWGRA2X4V++2lEBD84YVHwuF6gCbBqdA DwcLCe7c3R1vufwjWT8Ampw= =08D+ -----END PGP SIGNATURE-----