>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
I probably misunderstood something. Why do you need to do SELECT * from rank into temp? Why you can not just use Rank as RowSource for your combo and set it to be 2 (Alias)?. By the way, you should add nofilter clause for cases, where you select all fields from the original table...
If it's not broken, fix it until it is.
My Blog