Hi, I really need some help
I've got a program in visual basic designed for entering order information into a database.
I've got radio buttons where you can select the product and i need these when selected to declare that the rest of the information following is reffering to the specific product.
Each product has its own ID in the database so I created a public variable in a module
______
Public Product As Integer
______
On the form with the radio buttons i've made it so when selected Product becomes the correct ID number
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If BSRadio.Checked = True Then
Dim Product As Integer = 1
AddBS.Show()
ElseIf DNORadio.Checked = True Then
Dim Product As Integer = 4
AddDNO.Show()
ElseIf FNORadio.Checked = True Then
Dim Product As Integer = 2
AddFNO.Show()
ElseIf LFSRadio.Checked = True Then
Dim Product As Integer = 5
AddLFS.Show()
ElseIf SNORadio.Checked = True Then
Dim Product As Integer = 3
AddSNO.Show()
ElseIf WARadio.Checked = True Then
Dim Product As Integer = 6
AddWA.Show()
End If
Me.Hide()
End Sub
________
So i need to make it so the integer for the product links to that corresponding number in the database from microsoft access
Help me please!! lol
