Combo box on form help

[johnpaul]

Hi,



I am new to using Access, I have been using excel for a while now and have decided to try and move some of my lager spreadsheet into Access.

I am having an issue creating a dropdown box on a form
I have crated a table called Empinfo which has a field called Position on

There are 3 positions that I wish to enter into this cell:-
Business Manager
1st Assistant
2nd Assistant

On a form can I make a combo box which I can select one of these values and it will put it in the table Empinfo?

[RuralGuy]

The ComboBox wizard can help you complete this item. Have you used it?

[johnpaul]

The ComboBox wizard can help you complete this item. Have you used it?

Yes I have worked it out

Thanks for the reply

[RuralGuy]

Did you use a Value List or a Lookup Table?

[johnpaul]

Did you use a Value List or a Lookup Table?

Value List

Would it make any differance?

[RuralGuy]

With a Value List, if you want to change the list you need to call the Developer/Programmer. With a Lookup Table, you could set it up so the table could be changed by the user. Just more flexable.

[johnpaul]

With a Value List, if you want to change the list you need to call the Developer/Programmer. With a Lookup Table, you could set it up so the table could be changed by the user. Just more flexable.

How do I make it a look up table?

This would be much better for me

[RuralGuy]

That is why I brought up the subject. There is nothing special about a Lookup Table. It is just a regular table. I would suggest a table with at least two fields: AutoNumber PrimaryKey and Text field with the Values you want. The magic is with the ComboBox wizard. After making the table then try the ComboBox wizard again and let us know if you need further assistance.

[johnpaul]

That is why I brought up the subject. There is nothing special about a Lookup Table. It is just a regular table. I would suggest a table with at least two fields: AutoNumber PrimaryKey and Text field with the Values you want. The magic is with the ComboBox wizard. After making the table then try the ComboBox wizard again and let us know if you need further assistance.

Wonderful
Thansk for the help

[RuralGuy]

You are welcome. Remember to mark this thread as Solved when you get things working as you want.