Re: ListBox and Recno()

Author: PLBorkholder

Posted: 2005-01-26 at 10:42:46

Thanks everyone for the creative responses.

(Sorry I had to leave the office soon after I sent my 1st email yesterday)

Yes, the biggest problem is that the existing structure does not have a

PK. :(

I tried to use the list box indices however because the screen allows

the user to click on the labels above each "column" to sort the data in

that order ascending/desc, the indices do not match the underlying record.

I thought about using a grid, however, I like the multi-select option on

the list box which allows me to perform functions on the group of records.

I could always switch it all to a grid with a check box to the far left

but I wanted to avoid the complexity of that .

I could also just issue an SQL - Select statement and pull in the record

number with that.

Philip

©2005 PLBorkholder