468,780 Members | 2,254 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,780 developers. It's quick & easy.

ListBox Not Showing Rows?

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
Nov 13 '05 #1
1 2961
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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by JMorrell | last post: by
7 posts views Thread by Colleyville Alan | last post: by
1 post views Thread by Patty O'Dors | last post: by
4 posts views Thread by James Radke | last post: by
4 posts views Thread by Marcos Beccar Varela | GamaCom Argentina | last post: by
3 posts views Thread by perrycheung221 | last post: by
reply views Thread by zhoujie | last post: by
2 posts views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.