Printing a selected record

[mci]

Hi!

How can I print the selected record? I'm using visual basic 6. After I search the record, it display in the form but when I click the print button all the records will print. What I want is to print the selected record only.

Thanks!

[sashi]

Hi!

How can I print the selected record? I'm using visual basic 6. After I search the record, it display in the form but when I click the print button all the records will print. What I want is to print the selected record only.

Thanks!

Hi there,

Show us the code you included in the button click event, it's much easier you debug your code in that way, Good luck & Take care.

[mci]

This are the code for search button:
Private Sub cmdSearch_Click()
If OptWell.Value = True Then

Form1.Data1.Recordset.FindFirst "'" & TxtSearch.Text & "' = well"
End If
If OptJob.Value = True Then
Form1.Data1.Recordset.FindFirst "'" & TxtSearch.Text & "' = job"
End If
Unload Me
Form1.Show
End Sub


and this are for the print button:
Private Sub CmdPrint_Click()
DataReport1.Show
End Sub

the search and print command are working but I want to print only the selected record.
Thanks for your immediate response!

[mci]

I think I should create a program for the data report but I don't know what should I put on. pls help!!!

[desertsolider]

i think u jst need to use something like crystal report to do this

[Killer42]

i think u jst need to use something like crystal report to do this

Can't you just apply a filter to the datareport? (I'm not familiar with datareports, so can't say for sure.)

[damdam]

see the code below it will help you...
your datareport must set it source to the data environment that has a variable(text1.text) which will match and filter the record to be displayed in your datareport



If DataEnvironment3.rspayreg.State Then DataEnvironment3.rspayreg.Close
DataEnvironment3.payreg (Text1.Text)
DataReport3.Show

[mci]

Hi,

damdam, it works on my program. But I had a new problem.
I’m using VB form to add a record. After saving it, I used the datacombo to search for the newly recorded data and I can print also but if you add another record it doesn’t display in the datacombo. In order to see the newly added record I should close the program and run again.

Meaning it shows the saved record and can print it after compiling/running the program. I used data controller to store data and this are the code:

Private Sub CmdSave_Click()
MsgBox "Record Saved!"
Data1.Recordset.ADDNEW
Data1.Recordset.UPDATE
End Sub



For the datacombo (this are the code came from Deke):

Private Sub DataCombo1_Change()
If DataEnvironment1.rsCommand1.State Then DataEnvironment1.rsCommand1.Close
DataEnvironment1.Command1 DataCombo1.BoundText

DataCombo1.Refresh
Command1.Enabled = True
End Sub

Thanks,
mci

[Norilyn]

Hi!

How can I print the selected record? I'm using visual basic 6. After I search the record, it display in the form but when I click the print button all the records will print. What I want is to print the selected record only.

Thanks!