Christopher Jeris
cjeris at fas.harvard.edu
Tue Jun 12 13:28:58 CDT 2007
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
This may be a novice question, but I'm quite confused.
Fully updated Access XP on Windows XP.
I have created a form with a single listbox control, List0.
There is a table Table1 with a single TEXT(50) field field1, and a query
Query1 whose content is SELECT field1 FROM Table1 .
The form's class module has the following content:
Option Compare Database
Private Sub Form_Open(Cancel As Integer)
Dim qd As DAO.QueryDef
Dim rs As DAO.Recordset
Set qd = CurrentDb.QueryDefs("Query1")
Set rs = qd.OpenRecordset(dbOpenDynaset, dbReadOnly)
If rs.BOF Then ' no records
Cancel = True
Else
Set Me!List0.Recordset = rs
Me!List0.Selected(0) = True
End If
Set rs = Nothing
Set qd = Nothing
End Sub
(I know DAO is ancient, but the docs I learned from are all of Access 97
vintage, and I haven't learned how to work ADO yet. Other DAO code in
this project works fine.)
The problem I observe is that after
Me!List0.Selected(0) = True
the form hangs: all controls on it become unresponsive. The form can be
closed normally and Access itself survives.
What I want to do is just highlight the first item in the listbox by
default. What's going on here?
Thanks,
Chris Jeris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGbuXq5ICCNV0oGWARAuSAAJ9/ub1vUNPqZNK4rzTZPzl35aXnOACfVt1W
3OThlbDJ93d4lQyBafcX0I0=
=kyG4
-----END PGP SIGNATURE-----