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)

 

[access2010]

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

Thank you, Arnelgp for the MsAccess 2003 file, which is PERFECT for my request.

My boss has asked how to display the stock name when the Stock_Symbol has been selected, as she is concerned that the volunteers might choose the wrong Stock_Symbol.

Thank you very much
Frida

 

[access2010]

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.

Mokw123
Thank you for your suggestion.

Frida

 

[DHookom]

You could also combine the two fields into one expression with a Row Source of:

SELECT Symbol_Stock, [Symbol_Stock] & ": " & [Stock_Name] AS Expr1
FROM Investments01_tbl
WHERE Symbol_Stock Is Not Null
ORDER BY Symbol_Stock;

Then set the Column Widths to 0",3"