arage
04-04-2001, 12:40 PM
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
04-04-2001, 12:48 PM
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
04-04-2001, 05:52 PM
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
04-05-2001, 05:50 AM
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.