How do i open Form2 with the details of Contract#1 using the value from the listbox on Form1?
Posted on 2006-06-15
I have a Form1 - [Topic Information] with a list box that contains 3 columns:
1) the Contract_ID (hidden)
What I want to do, is select a value from my list box - "lst_Contract_Number" and open up a "Contract Details" page by passing it the hidden Contract_ID field from the [Topic Information] page. This is what I have so far. I am a ENTRY LEVEL programmer, so please make any expanation Barney Style! :-)
Thanks in advance
sql = "SELECT [Contract Information].[Contract Number],[Contract Information].SBIR_Phase,[Contract Information].Contract_ID,"
sql = sql & " Funding_Details.Contract_ID from [Contract Information] RIGHT JOIN Funding_Details on Funding_Details.Contract_ID = [Contract Information].Contract_ID"
sql = sql & " Where [Contract Information].Contract_ID = lst_Contract_Number.Column(1, 1)"