Setup Search Windows in SubForm

[PD1978US1]

Hi,

I have a normal Form window Where I click on a Button and it creates a report for me after I enteredFrom it into a Parameter box which appears. At the moment it is in the preview which I can printer manually.

Can I create a subform with a search function where I enter the exact same reference to output the report.?

My thought behind the whole issue is that I need to have a Form window open after I click on the Button Where I can enter the same reference. I want to make it look nice as well.

 

[Pat Hartman]

I am confused by the question so I will tell you what I do. The OpenReport method takes a where argument. I use that to control what the report shows. For example

Dim strWhere as String
strWhere = "MyID = " & Me.txtMyID
DoCmd.OpenReport "rptMyReport, acPreview, , strWhere

 

[PD1978US1]

The report shows Info I need. I have a form where I click a button. A parameter window / box opens. I enter the record I need and it shows. Its just that I want to make this box different from its looks.

 

[Pat Hartman]

Apparently, I'm still confused by the question.

You open the form first, then enter or find the record you want to report on, then press the "preview" button. If the record you want to see is on the form, why go through the extra step of prompting? Simply pass in the ID as you open the report. I'm not sure if you've noticed but when you prompt for parameters and open the report in preview, if you then print the report, you get prompted again. My suggestion eliminates that.

 

[PD1978US1]

here the link: https:// ibb.co/cS1y76

Maybe it's easier to recollect then, if I click the Normal HW Return Labels button, I get the "Enter Parameter Value" window.
Any way I can make this look better or nicer?

 

[Pat Hartman]

If you want anyone to look at your database, you will have to post it here.

My suggestion was and still is - DO NOT USE THAT METHOD. Use a form that you can format as you like. Let the form validate the input (which the popup dialog CANNOT do) and then run the report from a button on the form or the double click of some other textbox.