Access and VB code in a combo box

[Peter]

Need help to generate code in access combo box but in VB, i have done it
before but forgot

 

[Lynn Trapp]

You'll need to describe what you are trying to do.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Klatuu]

You are not likely to get an answer without a question. What would you like
the code to do?

 

[Peter]

Ok sorry guys,

I have a combo box in a form that lists the states in a country. I have
listed the states in a table and then combo box lists all the states in the
form. I would like to list the states in VB for the combo box instead of
having an extra table. The listed states stay the should stay the same so
they are fixed. Ihope this gives you better clarity

 

[Lynn Trapp]

Now I have to ask, "Why?" You can create a dynamic RowSource for your
combobox in VBA, but you would still have to have either a Table/Query or
Value List and, for a list of States, a table is the perfect place to store
that list.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html