Use selected combobox item to populate listbox

[samsquared]

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.

[Gicu]

Set the Row Source of the list box or the record source of the subform to something like this:
SELECT * FROM Dividents WHERE StockID = Forms!frmYourFormName!cboYourComboName;

Then in the AfterUpdate event of the combo requery the list box or the subform.
Cheers,
Vlad

[ssanfu]

Welcome to the forum...

Since you might want to total the amounts for selected stocks, consider using main form/sub form aet up.


Tables:

tblStocks
---------
StockID_PK - Autonumber
StockName - Text
StockSymbol - Text

tblDividends
------------
DividendID_PK - Autonumber
StockID_FK Long Integer (linked to StickID_PK from the Stocks table)
PayDate - Date/Time
Amount - Currency



Queries:

qryStocks - "SELECT StockID_PK, StockName, StockSymbol FROM tblStocks ORDER BY StockName"
qryDividends - "SELECT PayDate, Amount FROM tblDividends ORDER BY PayDate"



Main table : frmStocks
Record source: qryStocks
Default View: Continuous forms


Sub form: sfrmDividends
Sub form control - in the main form footer
Record source: qryDividends
Default View: Continuous forms

(Access may complain, but set both forms to Continuous forms view.)





Main form/sub form linking:
--------------------------
Link Master Fields = StockID_PK
Link child Field = StockID_FK

No programming necessary!
Select a stock in the main form, sub form is automatically updated.



And when you decide to total the stock dividend amounts, you can use the sub form footer for the total.


My $0.03 .....(inflation).

[samsquared]

Thank you both for your replies. I saw Vlad's first and successfully implemented it. Steve, I have other forms I want to do so I'll adapt your approach and give it a try!

[Gicu]

You're very welcome, good luck with your project!
Cheers,

[Praps]

I have a problem starting the property window, does any one know what to do when the property wikdow does not appear?

[mike60smart]

It usually means you have dragged the edge of the Window off the screen to the Right.

If you hover on the right Edge of your screen you should see the Icon for dragging the window to either the Left or Right.

[Praps]

have tried it did nt work, thank you any way

[mike60smart]

Can you upload a zipped copy of the database to see if it is the same on our PC's?

[Praps]

Can you upload a zipped copy of the database to see if it is the same on our PC's?

I have tried mz databas on mz wifes computer and there the property window appears as it has always do..

[Praps]

I have also tried out the MS Visual Basic Tools/Options/Docking tab hint and that did not help also, thanks to everybody for your help..

[Minty]

Try an MS office repair, that can fix "odd" problems?

[Micron]

this thread was hijacked and nobody noticed? I suspect that will mean that the suggested links at the bottom won't be applicable because the topic is now entirely different.
Perhaps the property sheet was placed on the view of a second monitor. Would probably have to connect the 2nd monitor to get it back or try post 4 here
https://www.accessforums.net/showthread.php?t=72575