>I don't understand why it doesn't work for you. This code works fine for me
>Dimension This.aFieldName[3,2]
>This.aFieldName[1,1]="\Last Name"
>This.aFieldName[1,2]="SearchTable.dHire"
>This.aFieldName[2,1]="\Date of Hire"
>This.aFieldName[3,2]="SearchTable.cLastName"
>This.aFieldName[3,1]="Social Security #"
>This.aFieldName[3,2]="SearchTable.cSSN"
>This.Rowsource=This.Rowsource
>
Jim,
You can change the last line to THIS.Requery() to get the combo to reread its rowsource. As a matter of fact you could put all the code in the requery and then whenever you want to refresh the combo, just call its requery