>Hi All,
>
>My form has a listbox that displays
>‘alltrim( person.lastname)+', '+substr(person.firstname,1,1)’, in the RowSource property, and 6 for RowSourceType. When I navigate with my toolbar my Refresh says ‘this.displayvalue=alltrim( person.lastname)+', '+substr( person.firstname,1,1)’. I want to clean this up a little. I am not proficient in working with data environments, so I need a little help. My listBox in the program will almost always be used for this purpose so I want to make my listbox class display this value so I don’t have to input it all the time. Something like this.dataenvironment.initialselectedalias. What is the most logical way of doing this and what should I do with my displayvalue property? I want my listbox to show the current record, be it the first or last record, it will always show the current record. There will be 2 other tables that will have a different set of names, so I can’t just put what I currently have in there (Person table) in my class. Any advice will be greatly appreciated.
>
>TIA

I would recommend you to have 2-column list with RowSource="table.lastname,firstname". This case Value property will reflect current record field value depending to what field your list is bound to. I would also say that Combobox or even Grid is a little bit better tahn List Bob for Table Navigation Form.