A formula would be used to set the value of the property bound to the combo box. It has nothing to do with setting the combo box row.

You can set the rows either with the Possible Values box on the Value tab of the control's Properties dialog or by using the List propety or AddItem method for the control. See http://www.outlookcode.com/article.aspx?ID=32 for sample code.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Michael Croy" wrote in message ...
I'm having trouble. I'm adapting an existing form to gather information from
a number of folks on global sales pipeline opportunities. I'll then import
that data into a database.

I'm able to create a number of fields, but I'm confused about creating a
drop down list and 'binding' it so I can have users choose from a list of
values.

I've tried creating the combo box, but it asks for a formula; I have no idea
what the formula needs to be.

As an example, i want a dropdown list to come up under a field called
"submitted by," and a choice of 20 names come up. How do i define that
field, and where do I store the values so they can choose the correct name?

If i can figure out this drop down problem, I will be able to finish and
publish this form.

Thanks in advance.