Problem with Listbox

[pser]

Hi,

I have a listbox on a form which use a query to get information about person which is registered. Problem is that sometimes the listbox won't show everything in the query. If i open the query direct i get everything, but not in the list box. I've even tried to put a button on the forms which contain Me!ListPerson.Requery.

Strange thing is that this just occurs now and then. Anyone got into this issue before?

Regards
Steven

Query is simple as this:
SELECT qPerson.Personnr, qPerson.Etternavn, qPerson.Fornavn, qPerson.AkademiskID, qPerson.StillingsID, qPerson.Grunnlønn, qPerson.LonnsGID, qPerson.AvdID
FROM qPerson
WHERE (((IIf([forms]![SlettRediger]![cmbValgtAvd]<>"",[forms]![SlettRediger]![cmbValgtAvd]=[qPerson].[AvdID],True))<>False));

 

[Pat Hartman]

Try adding an order by clause to the query. Unless a recordset is specifically sorted, there is no way to predict its order. And that order could change from execution to execution. You may think that data is missing simply because it is not where you think that it belongs in the list.