Hi Everyone,
I need help with combo boxes. I'm trying to create a form that updates a table. The table contains account numbers. What I want the combo box to do is show the account numbers so that I can choose from it. And then I want to input a new record to the table through the form of a transaction for that account that I choose. I figured out how to update the record in the table, however, I cannot figure out how to not have the combo box have repeated account numbers. I want it to only show the account number once. Does anyone know how to do this? I would really appreciate your help.
I need help with combo boxes. I'm trying to create a form that updates a table. The table contains account numbers. What I want the combo box to do is show the account numbers so that I can choose from it. And then I want to input a new record to the table through the form of a transaction for that account that I choose. I figured out how to update the record in the table, however, I cannot figure out how to not have the combo box have repeated account numbers. I want it to only show the account number once. Does anyone know how to do this? I would really appreciate your help.
