pull down menu

[paddy]

i was wandering if anyone could help me with a pull down
menu i have designed in a form.i want to construct it so
that it reads the name of a company, and then opposite
have the abbreviated name of the company. im having no
joy, and when i thought i had achieved it i got a message
saying that there was either too many options in my pull
down menu or that there was simply an error. there are 15
options, but i have an example database which has as many

 

[dawn]

there are various properties that you have to set to make
this work.

For example: I have a drop down list that displays a
username and an id with the following query in the

DATA TAB PROPERTIES ARE AS FOLLOWS
row source property "Select name, id from staffdirectory"
row source type is set to table/query
bound column = 2 (so that the field populates with the id)

FORMAT TAB PRORERTIES ARE
column count = 2 (this defaults to 1 so if you want 2
fields to show you need to increase the value)
column widths = 2";0.75" (this sets the width of the
columns in the drop down list)

my guess is that your problem lies with needind to set the
format tab properties so that your two columns will
display.