Combo box default value problem

[arage]

This…
Me.Combo156.DefaultValue = "300-110-7145-1000"
Does not give me this…
300-110-7145-1000
Instead it gives me this…
-7955
How can I fix this?

 

[arage]

Well, this seems to have done the trick…
Me.Combo156.DefaultValue = " ‘300-110-7145-1000’ ”
But now, how would I write the above & assign multiple values to combo156 and have those values appear in the dropdown menu part?

 

[gzuroweste]

arage,
This is how I do it.
If "Combo156" Value comes from a table,
Set the 'Control Source' property to that table.
In the 'Record Source'property, on the Data Tab, make a SELECT STATEMENT (ex: Select AccountNo,Somthing,SomethingElse From Customers ; )
Set the Column Count,on the Format Tab, to the number of fields in your SELECT Statement.
Finally Set the Column Widths to 1";0;0;etc;

[This message has been edited by gzuroweste (edited 04-04-2001).]

 

[arage]

Hi gzuroweste,
Is this acceptable, something I did before you posted your idea…

If GlobalRegDir = "Jon Doe" Then
Me.Combo156.RowSource = "'300-1500 Jackie', '300-1501 Paul'"
End If

My only problem now, is writing something other than what I’ve specified in the rowsource, I’d like to write 1500 instead of ‘300-1500 Jackie’ to the field.