dwAccessUser32
Programmer
I have a listbox that gets its values from a lookup table, tluPersonType.
The list box is on a page for entering information on a person and is used to allow users to select the category(ies) for the person (e.g., salesman, manager, etc.)
After a record has been successfully entered I can view all of the information except the original listbox selection(s).
I would like to write some code that shows what the previous selections were.
The listbox inserts into a junction table:
tjxPersonPersonType
PersonPersonTypeID
PersonTypeID
PersonID
So, the values should come from this table and be related to the listbox somehow with PersonID (I think) although the listbox itself has a control source of PersonTypeID.
Does anyone have any idea on how to do this? Any help would be greatly appreciated.
The list box is on a page for entering information on a person and is used to allow users to select the category(ies) for the person (e.g., salesman, manager, etc.)
After a record has been successfully entered I can view all of the information except the original listbox selection(s).
I would like to write some code that shows what the previous selections were.
The listbox inserts into a junction table:
tjxPersonPersonType
PersonPersonTypeID
PersonTypeID
PersonID
So, the values should come from this table and be related to the listbox somehow with PersonID (I think) although the listbox itself has a control source of PersonTypeID.
Does anyone have any idea on how to do this? Any help would be greatly appreciated.
