After selecting a Symbol, the Name Field is not being populated. (1 Viewer)

[access2010]

Could you please assist me in how to populate the SYMBOL_NAME from the dropdown field menu after selecting a symbol?

Thank you for your assistance
Frida

 

[moke123]

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.

 

[arnelgp]

create a query from investment table and remove unnecessary fields in brokerage table.

 

[xavier.batlle]

If you want or need to change the SYMBOL_NAME description after being selected, you have to assign the value in the Symbol_Stock AfterUpdate() event:

Me.Symbol_Name = Me.Symbol_Stock.Column(1)