CBO Easy Question

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;

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.

--
Good Luck
BS"D


"TKM" wrote:

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;