Hola, João,
If your RowSourceType is 2 (Alias) then the record pointer for the RowSource table will be at the correct record. Just look at the field you want, using your "TableToSearch" alias. Don't forget that you can use Name Expressions instead of macros
SELECT (TableToSearch)
and eval() of the field to get the values you need.
MyField = TableToSearch + '.c_descri'
? eval(MyField)
Espero ter ajudado
Barbara
>Hi,
>
>TableToSearch is my ALIAS(),
>then i select it with
SELECT &TabletoSearch
>
>so the
.RowSource=TableToSearch+'.c_codigo,c_descri,c_cp'
needs to be like that.
>
>>Are you tring to return the value of column2 after the user selects it?
>
>Yes, i need the value from column2 for comparision, (Remember is a listbox column) with what i'm typing in a TextBox after a SEEK.
>
>
>João Batista