Subform ComboBox Default Value

[djrolla]

I have a combo box in a subform that I can't get the default value to set.



For Row Source, I have three list items: "Email";"Phone";"Meeting".
Row Source Type: Value List
Default Value: [Mode of Communication].[ItemData](0)

Originally I set the default value to "Email" but that didn't work either. I want it to default to email. It defaults to meeting. What am I missing?

[ItsMe]

Default Value is associated with the Value Property. What you are describing is the Column Widths property. If you want all of your columns to display, Column Widths would be something like
1.5",1.5",1.5"

Also, you can choose which of these columns is the bound column. This will determine which column the Value property will look to. Adjusting the Bound Column to = 1 would bind the Email column. Then you could assign the value of Email to your combo to get it to default to a specific Row.

[hapm]

If you want your combobox to default to "Email" you need to set the Default Value property of course. And it should be the value you want it to have, no reference to the combobox again. So it should be simply "Email" (exactly as written in the record source). If the recordsource has multible columns, you need to use the value of the bound column. Be sure to set Email in quotes: "Email" so access doesn't try to evaluate it as a parameter.

[ItsMe]

If you want your combobox to default to "Email" you need to set the Default Value property of course. And it should be the value you want it to have, no reference to the combobox again. So it should be simply "Email" (exactly as written in the record source). If the recordsource has multible columns, you need to use the value of the bound column. Be sure to set Email in quotes: "Email" so access doesn't try to evaluate it as a parameter.

I am nopt understanding. To me, it seems the issue is the OP is trying to use the Column property of a combo to assign a Value to the combo. I do not believe this is possible. Hence, correctly set the Bound Column property and then
Me.Combo.Value = Me!SomeOtherField

or
Me.Comobo,Value = "An Email Address"
or
Me.Combo.Value = 12

[hapm]

The OP is not clearly written on this point. Looks for me as a bad try to set the default value for data entry or form load. Only speculation so.

[djrolla]

That didn't work. It was what I had originally tried. When I go to Edit List Items under Property Sheet, I typed each item on a separate line (email is first if that matters). Default value is a drop down, and I selected Email. Then, the Default Value would have "Email" automatically filled in.

If you want your combobox to default to "Email" you need to set the Default Value property of course. And it should be the value you want it to have, no reference to the combobox again. So it should be simply "Email" (exactly as written in the record source). If the recordsource has multible columns, you need to use the value of the bound column. Be sure to set Email in quotes: "Email" so access doesn't try to evaluate it as a parameter.

[djrolla]

From original post: "Originally I set the default value to "Email" but that didn't work either. I want it to default to email. It defaults to meeting. What am I missing?"

Still clueless (I'm new to this, in case you haven't figured out)

[ItsMe]

Have you considered any of my posts?

[atuhacek]

what is the controlling form? is your controlling form limiting the option? If not set the default value property =0 for your combo box.

[hapm]

We have to make some assumptions to help you, as your first post isn't very clear. Is the form bound to a record source? Is the combo box bound to a field? Did you add the combo box afterwards or is it a completely new form. Do you try to set the default value for a field of already existing records?