HELP

  • Thread starter Thread starter JOE
  • Start date Start date
J

JOE

I NEED TO GIVE A VALUE TO 10 ITEMS THAT I CREATED IN A DROP DOWN MENU AND
HWHEN THE ITEM IN THE DROP DOWN IS CHOSEN I NEED THAT VALE TO COME UP IN A
FIELD ( BOX )
 
Joe;

Have you thought about populationg a list box and using that selection
to be inserted into a field?

Good Luck

Toni
 
I NEED TO GIVE A VALUE TO 10 ITEMS THAT I CREATED IN A DROP DOWN MENU AND
HWHEN THE ITEM IN THE DROP DOWN IS CHOSEN I NEED THAT VALE TO COME UP IN A
FIELD ( BOX )
Click to expand...

First off... typing in all caps is hard to read and considered impolite; it
looks like you're SHOUTING AT US.

Secondly, a "drop down menu" - properly called a Combo Box - is not a data
repository; it's a display tool. Create a Table with your two fields and use
that table (or better, a sorted query based on that table) as the Row Source
property of the combo box.

To display the second column of the query when an item in the combo box has
been selected, set the Control Source of a textbox on the form to

=comboboxname.Column(1)

The Column property is zero based so this will be the second column.

If you're trying to do this in a Table, you can't; as a matter of fact you
should not have combo boxes in tables at all - see
http://www.mvps.org/access/lookupfields.htm for a critique of this misfeature.
 
Back
Top