cr help

[elixir_5000]

i am using vb.net with cr 8.0

i have inserted the cr viewer in form 10 but i need the value from the textbox1 of form7 plz tell me how to get that , i need to insert it inti the record selection formula.

Dim oapp As CRAXDRT.Application
Dim rpt As CRAXDRT.Report

Set oapp = New CRAXDRT.Application
cr1.ReportSource = rpt

rpt.RecordSelectionFormula = "{DATA2.gba}=" & val(Form7.Textbox1.Text) & "" 

i have a combobox which on load of the form takes the values from the database table now waht i want is that if i press any alphabet say "k" then combobox must open and all the values in the combo box starting with k must be shown

[michaelrawi]

I suggest you learn how to communicate within forms. Some users in this forum have the link on their signature.

[code]rpt.RecordSelectionFormula = "{DATA2.gba}=" & val(Form7.Textbox1.Text) & ""[code]
Form7 is an object. To use an object, you have to set a reference on it. What object did you use to declare as Form7 ? Also, you should modify it's access modifier to public (don't use dim or private)

Ex. If you have

Public frm7 as New Form7 

You can access all frm7 objects like this:

frm7.textbox1.text 

[elixir_5000]

Originally Posted by michaelrawi

I suggest you learn how to communicate within forms. Some users in this forum have the link on their signature.

[code]rpt.RecordSelectionFormula = "{DATA2.gba}=" & val(Form7.Textbox1.Text) & ""[code]
Form7 is an object. To use an object, you have to set a reference on it. What object did you use to declare as Form7 ? Also, you should modify it's access modifier to public (don't use dim or private)

Ex. If you have

Public frm7 as New Form7 

You can access all frm7 objects like this:

frm7.textbox1.text 

i dont know y but it does not carries the value of text box with it

[RobDog888]

Depending on the version of VB you have, 9.0 comes with Pro and above.