Combo Box

rmartinez

New member
Local time
Today, 04:43
Joined
Jun 19, 2007
Messages
8
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. :o
 
Base the combo box on a query which lists the account numbers. You can ensure that the query only has one instance of each account number in it by using DISTINCT in the SQL. The DISTINCT clause can also be set by using the 'Unique Records' option when you right click in the top half of the query design view.
 

Users who are viewing this thread

Back
Top Bottom