This should be a fairly easy question to answer. (I used to be quite adept at Access but since retiring have become rusty.)
My database has two tables:
Stocks - ID, Stock Name, Symbol
Dividends - ID, StockID (linked to ID from the Stocks table), Pay Date, Amount
All I want to do is to have a form with a combobox that lists the stocks I own and when I select one, it uses the Stock ID to select the appropriate rows from the Dividends table to populate a list or subform also on the form. Later I may also want it to total the amounts for the selected stock.
What's the easiest way to do this? I have other things I'll want to do but this should get me started.
Thanks.