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