471,071 Members | 1,137 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,071 software developers and data experts.

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

nothing shows.... and if I do a

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?
Nov 13 '05 #1
1 3049
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

Sheesh!.... that was about six hours down the drain....
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.