CBO Easy Question

T

TKM

I have a main form with a subform. I also have a cbo named "Insurered"

I would ike the CBO to default to "PENDING" but it willnot no matter what I
do. I have tried using the number that that pending is associated with which
is 9, I triedd using the name pending in the default box. I have tried
everything. Here is the row source.. Please help!

SELECT tlkFieldCodes.FieldCodeID, tlkFieldCodes.FieldCodeDesc FROM
tlkFieldCodes WHERE (((tlkFieldCodes.FieldCodeGroup)="Insurered")) ORDER BY
tlkFieldCodes.FieldCodeID;
 
O

Ofer Cohen

Is that combo UnBound?
If that the case setting the default property won't work, ýou'll need to set
the value in the combo using the form load event

Me.ComboName = 9

Also, if the combo is bounded it will work only with new records, and it
won't work for existing records where the value in the combo is empty.
 
Top