Populate new form based on Combobox

[Rabastan]

I am trying to learn VB 2010. I have an Starting form with a combobox that has the following code.

Public Class frmStartScreen

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddSoftware.Click
    frmAddSoftware.Show()
    Me.Close()
End Sub

Private Sub frmStartScreen_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    'TODO: This line of code loads data into the 'Data_dbDataSet.tblSoftware' table. You can move, or remove it, as needed.
    Me.TblSoftwareTableAdapter.Fill(Me.Data_dbDataSet.tblSoftware)

End Sub

Private Sub cboChooseSoftware_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboChooseSoftware.SelectedIndexChanged
    Me.Validate()
    Me.TblSoftwareBindingSource.EndEdit()
    Me.TableAdapterManager.UpdateAll(Me.Data_dbDataSet)
End Sub

Private Sub btnGoToSoftware_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGoToSoftware.Click
End Sub
End Class

When "btnGoToSoftware" is click I want the next form to open with labels populated based on the selection. As of now i have 4 fields. idsSoftwareID, chrSoftwareName, dtmSoftwarePurchaseDate, chrSoftwareCompany in a table.

I am using chrSoftwareName to populate the Combobox. When the go button is clicked I want to open a new form with labels populated based on the chrSoftwareName in the combobox.

Thank You
Rab

[kareninstructor]

Hello,

Before getting into code and fields I would suggest explaining exactly what you want beginning with what information is being displayed on the first screen as the code shown is generic in nature expect for the word "Software".

Also I would highly suggest reconsidering names of fields in your table, each one of your fields currently has the word software in it, this is not needed, instead your table name would describe what the table is for, in this case "Software". With that said idsSoftwareID would become either ID or Identifier, chrSoftwareName would be Name or Product etc. dtmSoftwarePurchaseDate would be PurchaseDate. So a SELECT statement would be

SELECT ID, Product, PurchaseDate FROM Software

What if we add in a category? We can alias each column by table name i.e.

SELECT 
   Software.Product, 
   Categories.CategoryName, 
   Software.PurchaseDate 
FROM 
   Categories 
INNER JOIN 
   Software ON Categories.CategoryID = Software.CategoryID

OR

SELECT 
   Product, 
   CategoryName, 
   PurchaseDate 
FROM 
   Categories 
INNER JOIN 
   Software ON Categories.CategoryID = Software.CategoryID

So if you wanted to get used categories we would use

SELECT DISTINCT  
   Categories.CategoryName, 
   Software.CategoryID
FROM 
   Categories 
INNER JOIN Software ON 
   Categories.CategoryID = Software.CategoryID
WHERE 
   Categories.CategoryID = Software.CategoryID

What I am trying to say is first get your requirements down on paper (or software such as Visio) then build your database with meaningful names and relationships. When you hit a barrier come back and explain in plain English what the problem is. Again as stated above, showing the code shown does no good as it is simply generic in nature.

Here is a good resource for coding
http://msdn.microsoft.com/en-us/library/fxsa23t6.aspx
For modeling databases
http://www.databaseanswers.org/data_models/index.htm