>I need to display a list box with multiple columns. The data source for the list box is a table, and the colums have data of diiferent types - character and date to be specific. I have a command button that skips through the table one record at a time, and I want the row to highlight with each skip. The problem is that the data comes i blocks. For example, I might have 10 or 12 records where the character data (name) is the same. Pressing the button skip ahead ok, but the highlight in the list box doesn't move until the record in the table has a different name.
>
>I have the rowsourcetype set to fields, and the rowsource is name,date (the fields in the table). I have the controlsource set to a variable (character) which I reset each time the command button is clicked. I am stumped !
>
>Anybody got any ides ?
>
>TIA
>
>Bill Perkins
>Cabaret Development LLC
>bperkins@cabdev.com

Bill,

My first suggestion would be to use a set based solution instead of aliasing a table. There are a number of reasons for this, foremost being reliability and speed. List boxes like character fields, and will try to change everything to character to build the list. A simpler method might be to use a grid. You can set the grid lines off, and make the grid read only and such as necessary to get the behavior you want.

I can give you specifics if you like.

Regards,

Jason