How do I populate a List Box with the contents of the values in a field in a Code Table so that users can choose from the list?
Is a ListBox the best option for this?
The list is in a Code Table which has 'Code'& 'Description' as its two fields.
I want the Users to be able to select from a list of Descriptions that is in the table & then insert the appropriate Code into another Table after the user has selected.
I'm sure this has been covered somewhere but I have not been able to find it. Please point me in the direction of some code if I've missed it.
Is a ListBox the best option for this?
The list is in a Code Table which has 'Code'& 'Description' as its two fields.
I want the Users to be able to select from a list of Descriptions that is in the table & then insert the appropriate Code into another Table after the user has selected.
I'm sure this has been covered somewhere but I have not been able to find it. Please point me in the direction of some code if I've missed it.