Link to another form

[dr223]

Hallo,

I have a form called FrmPracDetails, which has details of practices and each practice has a unique prac_no populated on the form in the text box called TxtPracNo.

Now, I have another form called FrmPayHistory. This form has a datagrid called DgvPayHistory, which is loaded with all the payment history of all practices. It has also a field called prac_no and stores the unique prac_no.

What I want to do is, when a user is in FrmPracDetails, lets say prac_no - 1155, then you open the FrmPayHistory. Only the payment history of that respective prac_no should be seen. Presently, it brings all the practices and their payment history.

I have added a textbox (TextBox1) in the FrmPayHistory which links and displays the prac_no from FrmPracDetails with the following code;

Me.TextBox1.Text = FrmPracDetails.TxtPracNo.Text

Could anyone tell me the code for this? Thanks

[sotoasty]

Create a property on the FrmPayHistory called PracNo


Private mvarPracNo as String
Public WriteOnly Property String PracNo()
Set (ByVal value as String)
mvarPracNo = value
LoadData
End Set
End Property

Private Sub LoadData()
SQLCommand.CommandText = "SELECT * FROM Table WHERE ID=@ID"
SQLCommand.Parameters.AddWithValue("@ID",mvarPracNo)
... execute your command and populate your data here
End Sub


In your calling form

Private Sub OpenHistoryForm()
DIM OHF as new frmPayHistory
OHF.PracNo = Me.TxtPracNo.Text
OHF.ShowDialog() ' Or Show() if defined in the form
End Sub


Now anytime you set the PracNo property of the frmPracPayHistory, the form will load the data of that ID.