PLS HELP: Query tied with form Access 2007

[oltroman]

Hi,

I put this code in Query under criteria

Like [Form]![SearchForm].[qBarcode] & "*"

In the SearchForm I put this code in BtnRunSearch

Private Sub BtnRunSearch_Click()
DoCmd.OpenQuery "Query2", acViewNormal
End Sub

However the problem is When I hit BtnRunSearch (Button), Query2 act like there's no input to "qBarcode" which is a text Box. I dont understand this. Can anybody help pls. I am using Access 2007

A Popup window asked for an input for Query.

 

[pbaldy]

See if this works as the criteria:

Like Forms![SearchForm].[qBarcode] & "*"

 

[oltroman]

I see, I miss a "S", Thanks a lot

 

[pbaldy]

No problemo.