get rid of the lookup fields in your tables.
Use a separate table for the stock symbols and names and store the primary key as a foreign key in your other tables.
then your textbox is for display only and you can use something like: =[Symbol_Stock].[column](1) in the control source.