I'm having trouble getting a ListBox to display all of the data in the table it's pointed to. The user selects a record from the parent(master) table that they want to see detail on and a SQL Select creates a temporary table from data in the child(detail) table for only the record selected. The ListBox's rowsoruce contains the field names of the temporary table and does properly display all of the records. However, if the user then selects a new record from the parent table to view details on, the ListBox only displays up to the same number of records as were displayed the first time. If more records exist, they only show in the ListBox after the user clicks inside of the ListBox. It seems to me that the ListBox just isn't refreshing properly, but I've tried restating the rowsource property and refreshing the ListBox right after the SQL Select command and it still acts the same way.

Does anyone have an idea on how to fix this? I can give you details on property settings and code if needed.

Thanks for any help,
Wes Hopkin
VAST Software, Inc.