>Hey All,
> Is there a way to list combo box options from another table. I am trying to use SQL command to do this. Let say the name of the table is rank. Please tell me what I am missing or not doing right.
>
>My code
>select *
>from rank
>into cursor temp
>
>The combo box does not have a value after selection. can someone help me out or give me a piece of this small code?
>Thanks,
>Tom

Tom,
You can do it as Tim said. Remember when rowsource is SQL, alias or fields you don't ever need the value. You can just query rank.somefield
Cetin