Bound = .F. ControlSource = ( IIF ( SEEK( MyRecordSource.MyForeignKey, 'MyLookupTable', 'MyLookupTag' ), MyLookupTable.Description, '' ) )Set up the combo with any RowSourceType except for 2-Alias or 6-Fields (using one of these RowSources will make the combo go blank when it has focus) like this:
ControlSource = MyRecordSource.MyForeignKey BoundTo = .T. RowSourceType = 3 RowSource = SELECT Description, PKField FROM MyLookupTable ORDER BY Description INTO CURSOR csrLookup NOFILTER