Getting Data from Table based on text boxes (1 Viewer)

[x18access]

Hello, my problem seems to be very familiar to the one in this thread :

http://www.access-programmers.co.uk/forums/showthread.php?t=234613

Basically I have a list of tables in one combo box.
I want the user to select which table.
( The tables are stock information, each table for each different day of the stockmarket)

Then they select the Stock they want to look at. ( These are the same in all the tables obviously, so it is the same in the drop down box)

NOW, the bit i'm struggling with.
Is for a textbox below to show the value found IN the table name selected, with the stock selected.


How would i do this in SQL, or VBA with SQL.

I really need some help, I have been struggling on this for hours.


Regards




Matthew

 

[Alansidman]

Why would you have a table for each different date. This sounds contrary to data normalization. Perhaps if you normalized your data, it would be easier to extract or find or search for the information you seek. Look at this white paper on RDBMS fundamentals.

http://sbuweb.tcu.edu/bjones/20263/Access/AC101_FundamentalsDB_Design.pdf