Hi Tom.

>> 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. <<

You can, as Nadya said, use the Rank table directly as your RowSource. Set the combo up like this:

RowSourceType = 2-Alias
RowSource = Rank
BoundColumn = < whatever column you want the value to come from >
BoundTo = < .T. if the BoundColumn pooints to a numeric field >

>> The combo box does not have a value after selection. can someone help me out or give me a piece of this small code? <<

Does your combo have a ControlSOurce? If it does, it should display a value if the field to which it is bound has one that is in the combo's Internal list.

Or do you want to initialize your combo to some value when adding a new record? If this is the case, you can just set the combo's ListIndex to 1.

Marcia