By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

listbox: missing rows

P: n/a
I have a listbox that will only show the header row and the first
record regardless of how many records are returned. I can find no code
or settings that account for this.

- The list box is on the main form
- The rowsource for the listbox is updated from a subform with the
following code:
With Parent!lbo_SQL
.RowSource = str_tempSQL
Parent.txt_RecordCount = .ListCount - 1 'subtract 1 to
account for the header row
End With
- the .ListCount will show the correct number of rows that should be
returned by the SQL, but the listbox will only show the header row and
the first record.
- str_tempSQL is a valid SQL string that I build in this porcedure

I've checked everything I can think of. Any suggestions? I know this
has got to be something simple that I'm just overlooking.

Apr 25 '06 #1
Share this Question
Share on Google+
2 Replies

P: n/a
Check your listbox properties. Maybe you set it to show only one

Apr 25 '06 #2

P: n/a
How woudl I set it to show only one record?

Anyway, I just closed out of the db, and reopened it. The list box will
fill with all records if the record set has more thatn one record.
Howeer, if I go into design view, and then back to form view, I won't
see all records, just the first. If there are enough records to more
thant fill the list box, the scrollbar will NOT show until I use the
arrow keys to move in the listbox past the currently hidden records.
Only then will the rest of the records, as well as the scrollbar

Weird. HELP !

Apr 25 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.