Hello fellow Access peep's,
I have a list box on my main menu which has a query behind it showing me all leads that require a follow-up. The list box contains First name, surname, lead date & status. All but the status column are displaying correctly. The value however in the status column shows a number rather than the text value.
The status value when entering a new lead into the DB is done by selecting from a combobox. The combobox gets it's info from a table called status. I suspect the problem to be that the list is picking up the StausID value and somehow I need to reference the column of the combobox that contains the text I want to display. If this is the case I'm not sure how to do this therefore I am here asking for your help.
Thanks in advance
I have a list box on my main menu which has a query behind it showing me all leads that require a follow-up. The list box contains First name, surname, lead date & status. All but the status column are displaying correctly. The value however in the status column shows a number rather than the text value.
The status value when entering a new lead into the DB is done by selecting from a combobox. The combobox gets it's info from a table called status. I suspect the problem to be that the list is picking up the StausID value and somehow I need to reference the column of the combobox that contains the text I want to display. If this is the case I'm not sure how to do this therefore I am here asking for your help.
Thanks in advance