Combo Box

[JayX]

I created a combo box but when I choose one of the employees that I have in my company it shows up multiple times in the other combo boxes. How do I set it so when I chose an employee it will only show in that specific combo box and not the others.

[pbaldy]

It sounds like you have a form in datasheet or continuous view, and the combo box isn't bound to a field in the form's source. It needs to be.

[JayX]

Well when I imported my excel sheet I chose 'Tabular View' So when I put one combo box there are 30 which is what I want because I have 30 supplies in the company that I need to keep track of. I just need a combo box to choose a list of employees from if they were to take something out from the inventory list....

[JayX]

but how do I get it to stop saying someones name multiple times in all 30 combo boxes and to show up only once?

[pbaldy]

Can you post a screen shot of the form in design view?

[JayX]

here is a screenshot of what i am working with

[JayX]

I need to choose from my employees so it only shows up one time, not 30 times of the same name

[pbaldy]

That's not design view, but it looks like what I suggested. My guess is that the combo is not bound to a field in the form's source, which will make it do that. If you want to associate an employee with each record, there needs to be a field in the data to store it in.