openReport [where] condition brings up input box instead of finding correct value

[neockder]

Thank you guys in advance for the help. I've luckily had a great mentor to hound when questions come about, as for now I Need all of You!

I'm trying to open a report using the following code:


Private Sub openCellarRpt_Click() DoCmd.OpenReport "cellarRPT", acViewReport, , "brewID = " & Me.subSchedBrew.Form.brewID, acDialog
End Sub




This opens the report 'cellarRPT' in dialog view, with the where condition setting the field 'brewID' on the report to the field 'brewID' located within a datasheet-view sub form 'subSchedBrew' on the main form that houses the button. I've used a very similar where condition on other forms/reports with great success. It's merely pointing at one record, and pulling up associated records in a linked table.

In this case, i click the openCellarRpt button and it brings up an input box, which finds the value, but asks for it again. Title: Enter Parameter Value, Discription: The Value I need to link the report! If I copy the description into the input box, which is the value I'm looking for it to find, then it works perfectly. Otherwise it crashes.

This picture should help explain, and thanks again for any help!!

[ssanfu]

One thing to check>> Do you have a field named "plan1294"?
Somewhere, I think you typed in the data instead of the field name. (query maybe)

Anytime a parameter value is asked for, it means that a field name in a query is not recognized/found.

[neockder]

Hmm, ok. Thanks for the response. What's weird is that it finds the correct value, from the correct record and field. The field is 'brewID,' which it finds. plan1294 is the record i'm looking to find (in this example).

I'll definitely take a look at the queries in relation to that field, as those values are automated based upon some variables when created, and then changed when a status field changes.

Thanks!

[pbaldy]

Note the different syntax for a text field:

BaldyWeb wherecondition

[neockder]

Note the different syntax for a text field:

BaldyWeb wherecondition

Thanks Baldy! You rock. That fixed it! Now I just need to play around with the query looks like, as it only brings up records in which a certain value is not null

[pbaldy]

Happy to help!

[neockder]

is there a way to mark this solved?

[pbaldy]

Yes, under Thread Tools at the top of the thread.