I have 2 tables, Securities and Transactions. In a form which I use to record a transaction, I have the text boxes Date, Symbol, SecurityName, BuyPrice and SellPrice. When entering the "Symbol" I would like to have the Security Name show, which is drawn from the Securities table. I tried this...