weird listbox behavior - just upgraded to Access 2007

[Sean Kelly]

I have a form, frmList, which is used to maintain a number of lists, such as
Languages, Outcomes, Reasons, Workers, etc. On the main screen, when
the user chooses a list to edit, frmList loads with a listbox, and
several buttons (add, delete, edit, close). The listbox is populated
with all the options for that particular list.

For some reason, after we converted to 2007, the listbox opens blank
(or appears to be blank) when the user tries to edit Outcomes. With
the other lists, the form works as expected. frmList has reusable
code. One variable, strQueryName, is the only thing that is different from
list to list.

I say "appears to be blank" because if I click on the top "record" or
the top row where a record should be... and then arrow down, the list
options start to appear. Like the screen repaints or the forecolor is
changing... Like i said, all the other lists load properly and
completely.

Anyone else have this problem? The Record navigator at the bottom of
frmList says record 1 of 10 otherwise I never would have known the
records were actually being pulled.

Any ideas would be appreciated.

 

[Jeanette Cunningham]

Hi Sean,
I haven't heard of this happening to other databases.
First I would suspect the listbox has become corrupted.
Try adding a new listbox for outcomes to see if a new one works correctly.

If this doesn't help, try creating a new form for frmList.

If that doesn't help, try the recovering from corruption steps on Allen
Browne's website.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia