ListBox Not Showing Rows?

[(PeteCresswell)]

One form, two list boxes.

The left box's .RowSource is a query into a work table that selects items where
!IsSelected = False.

The rite box's .RowSource is a query into the same table that selects items
where !IsSelected = True.

If the user doubleclicks a row in the left listbox, DblClick event code sets
!IsSelected=True, updates the record, and requeries both boxes.

Problem is that the rite box doesn't show any rows (although it's .ListCount =1
in spite of .ColumnHeads=False.

Even if I go into the Immediate window and do a
Forms!frmWhatever!lstRite.Requery,

nothing shows.... and if I do a
?Forms!frmWhatever.RowSource,

the expected query name is returned... and if I open up that query
independently, the expected items show.

The zinger is that if I go into design mode and to a copy/paste of the offending
listbox into a new form, it does show it's rows.

Gotta be something with the form, right?

But what?

I've tried doing a SaveAsText and LoadFromText in case the form is corrupted,
but no luck.

Anybody been here?
--
PeteCresswell

[(PeteCresswell)]

Per (PeteCresswell):

Gotta be something with the form, right?

But what?

Turns out that the form was spontaneously deleting the .RowSource - or something
like that.... kinda weird bc the ?.RowSource returned the name of the expected
query... but it just wasn't having any effect.

Threw in a few lines of code here-and-there to set .RowSource and it's back in
business.

Sheesh!.... that was about six hours down the drain....
--
PeteCresswell