Open report on value of textbox

[blueraincoat]

Hi All, I have a report based on a select query. How could I open the report by clicking a button on a form and the criteria input dialog does not show up but automatically get the value of a textbox from the form?
Should I use the wherecondition, or OpenArgs?
I tried this but it didi not work.

Private Sub Command2_Click()


DoCmd.OpenReport "rptPartsList", acViewPreview, , , , OpenArgs:="Me.txtRepairID"
End Sub

Could somebody give any suggestion?

[ssanfu]

The criteria row in the query would reference the control on the form.

For more specific info, please post the SQL of the report query, the name of the form, the name of the control that you enter the number into and the name of the field that is filtered.

[blueraincoat]

I made a sample db, please take a look.
Thanks in advance.

[blueraincoat]

https://www.accessforums.net/reports...ery-12307.html

I opened another thread and it has already been solved.

[ahmad]

plz tell me code to open access report when enter text in textbox from form

[blueraincoat]

It's something like this:

Private Sub Command11_Click()
DoCmd.OpenReport "rpt228-7Analyze", acViewPreview, , "RepairID='" & Me.RepairID.Value & "'"

End Sub

there's something you may reference to
http://www.baldyweb.com/wherecondition.htm

[ahmad]

hi, blueraincoat. thanks 4 reply but plz solve my problem. i have make a form & take a button and textbox1. i wanna do that when i enter string("name" as table1 entry) in the textbox1 and click to button, then open report of same string as i entered in textbox1. in short, open report by taking text of textbox1.
plz help me

[ahmad]

plz reply if anybody knows about it

[blueraincoat]

you can add a command button click event to accomplish this,below is the code
Private Sub Command_Click()
DoCmd.OpenReport "rptYourReportName", acViewPreview, , "Name='" & Me.textbox1.Value & "'"

End Sub

if possible,you can post your db and maybe I can help you with it

[blueraincoat]

I have another thread on the same issue,and Paul gave a very useful information that
"If you still have a criteria in your query for this same value, you should take it out. The wherecondition argument of OpenReport replaces it."
Hope this will help you out.
https://www.accessforums.net/reports/...ery-12307.html

[ahmad]

thank you so much blueraincoat. one more problem is coming. when i enter 6 digit number in textbox1 according to field "idno" and click button, error is coming. plz help, if it will solve then there are no problem in my database. so plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz help.

[blueraincoat]

If this filed is a numeric value you have to take off the single quote.
http://www.baldyweb.com/wherecondition.htm
Hope this help

[ahmad]

thank you blueraincoat.

[ahmad]

is it possible that access report open directly from vb6 button click?

[ahmad]

i mean, enter text in textbox and click button to open particular report directly.