listbox: missing rows

[Daron]

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.

Details:
- 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.

[manningfan]

Check your listbox properties. Maybe you set it to show only one
record?

[Daron]

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
appear.

Weird. HELP !