Report with parameter from form

[simma]

Hello
Im trying to bring up report with one of field criteria comming from form.I have following code.But whenever I run the code input box opens up asking for parameter.Please let me know what Im doing wrong.
Thanks

Dim stDocName As String
Dim stLinkCriteria As String
Dim strarea As String
stDocName = "RptDefault"
cboarea.SetFocus
strarea = cboarea.Text
DoCmd.OpenReport stDocName, acPreview, , "Item_Source = " & strarea & ""

 

[dhookom]

Use the Value property (or no property) rather than the Text property. If the value truly is a string value than modify your code to:
DoCmd.OpenReport stDocName, acPreview, , "Item_Source = """ & strarea & """"

If you are still getting an input box, tell us what the caption is. I assume [Item_Source] is a field in the record source of your report.

Duane
MS Access MVP

 

[simma]

Thanks dhookom !! It works..