>>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.
Thanks everyone for the help
Edward,
for my purpose, a 2 col list would be inappropriate. My listbox allows me to select the record I wish to work with, once selected there are 22 textboxes with their information and I just tab to each field and input their data. That is why I elected to create a class of this form, because it is used generically for my history and inbounds personnel tables. I am having difficulty in refrencing the heiarchy of these objects and data environments. I want the list box to display lastname and firstname initial, regardless of which table I'm in (personnel, history, inbounds...) I should do this in my class, but how. I don't want to rely on my v. 2.6 way of doing things. Another problem I found is when I add a new record to the table. When I append a blank my RowSource property has a fit and creates an error. I believe that if I were to tie all this to the data environment cursor this will satisfy the functionality I desire. Any and all help/suggestions will be greatly appreciated.
TIA
Jon Paskett
Microsoft Certified Systems Engineer
We all have to start somewhere...
Sometimes over again!