>>
>>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

IMHO I don't see why 2-col list will be not OK. The problem is bounding to data. If you are going to fill list from different tables, you probably should use RowSourceType=2 (alias), create cursor (lastname,firstname) in Form.Init and refill it (requering list) each time you change table. In List.InteractiveChange event you could fire some custom RefreshData method to fill textboxes with new record data depending on table name again.