J
jhoga
Guest
I'm having trouble setting the value of fields in a user form based on a selection made in a second form. The first form brings up an SQLServer base datagrid. In form2 I have set the grid click event as follows:
Dim myRow As Integer
Dim myCol As Integer
Dim myVerification As String
myRow = myGD.CurrentRowIndex
strSelLastName = myGD.Item(myRow, 1)
strSelFirstname = myGD.Item(myRow, 2)
strSelMI = myGD.Item(myRow, 3)
strSelAddress = myGD.Item(myRow, 4)
strSelCity = myGD.Item(myRow, 5)
strSelZip = myGD.Item(myRow, 6)
Now i want to set form1.textbox1.text = strSelLastNAME
I have set strSelLastName as Public string in a module.
Ahelp on how to reference a control in anougher form would be great.
Dim myRow As Integer
Dim myCol As Integer
Dim myVerification As String
myRow = myGD.CurrentRowIndex
strSelLastName = myGD.Item(myRow, 1)
strSelFirstname = myGD.Item(myRow, 2)
strSelMI = myGD.Item(myRow, 3)
strSelAddress = myGD.Item(myRow, 4)
strSelCity = myGD.Item(myRow, 5)
strSelZip = myGD.Item(myRow, 6)
Now i want to set form1.textbox1.text = strSelLastNAME
I have set strSelLastName as Public string in a module.
Ahelp on how to reference a control in anougher form would be great.