Default Value on Combo Box with two columns

[handlebarry]

hi - Having some problems seeting a default value and I think it's because there is more than one column (column widths set to 0cm,2cm)

Trying to get it to default to the first record in a table.
By amending previous threads I got to:

DMin("tblTeamLeaders.lngEmpID","tblTeamLeaders.strEmpName")

this is not working
any help appreciated

 

[handlebarry]

Me.cboEmployee.DefaultValue.Columns ?????

 

[handlebarry]

tried Me.cboEmployee.DefaultValue.Column(1) = "CWGLogin"

but this is giving me an invalild qualifier error

 

[Eupher]

Hi, handlebarry,

I think you can only set the default value by using the bound column. Are you trying to set it in VBA? Or in the control's Default Value field in the property sheet?

I just tried it with both DMin and DMax in the control's property sheet and it worked:

=DMin("[MyField]", "MyTable")

Ken S.

 

[Eupher]

p.s. And if you're trying to set it in code, remember the DefaultValue property is a string. If you try something like this, which *seems* like it should work, you may get strange results:

Me!Combo3.DefaultValue = DMax("[SSN]", "Members")

The above code resulted in a value of -9099 in my combo. Why? Well, the max SSN value in my table is 999-99-9999. Yup, 999 minus 99 minus 9999 equals negative 9099. However, this code works exactly as expected:

Me!Combo.DefaultValue = "=DMax('[SSN]', 'Members')"

This also worked:

Me!Combo3 = DMax("[SSN]", "Members")

However, you would want to be very careful where you placed this last example, as it would replace any existing value in the control.

HTH,

Ken S.