On the Value tab of the control's Propeties dialog, clear the check box for "Set the initial value of this field to"

--
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 ...
Thanks Sue. I guess I need to go buy the book because I'm missing a lot.
When I create the combo box to start it asks for a formula before i can do
anything. I dont know what that formula is, so I can't even create the box.
It tells me 'A formula can't be empty." So I can't even get to the next step
that you talk about.


"Sue Mosher [MVP-Outlook]" wrote:

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.


"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.