Adding fields in existing drop down menu?

[snowboarder234]

Have a drop down box with 2 fields, ie;


Melvyl
Scotty

Now, boss wants to add a third field. I'm not sure how to do that without loosing the current fields.

[pbaldy]

You'd add the field(s) to the row source query, adjust the column count and column widths properties accordingly.

[pbaldy]

Though by your description, do you mean add a third record? If so, you'd add a record to the table the row source pulls from, or another value to the value list.

[davegri]

Show us what you have in the 2 examples: These will show properties of your dropdown.

[snowboarder234]

Show us what you have in the 2 examples: These will show properties of your dropdown.

You guys are amazing. The graphic davegri provided helped me to figure out how to add more values to the drop down box, ie;
WorldCat
Scotty
Berkeley
Melvyl
Now I need to know how to add a blank field to the drop down field to the existing combo box.

[pbaldy]

Either Null or "" should work, depending on what you want to do with it.