Solved Criteria based of text box on form not working (1 Viewer)

[murray83]

I have the following in criteria for a query which should list user answers based on name, but i get blank query, it doesn't even ask me to input anything if the form is blank

"Forms![F_Start]![txt_UserName]"

Please help me AccesWorld your my only hope

cheers all

 

[Gasman]

Well it would not have quotes for a start.

 

[murray83]

Well it would not have quotes for a start.

ok sorry thing i added them as was searching else where, and they had em. but the query runs fine when remove the criteria section

 

[murray83]

Cheers but i have fixed it. The text box looking at was unbound so have added another box and made that control and boom works

[Forms]![F_Start]![txt_UserLookupResults]

cheers for the tip on ""

 

[Gasman]

That should not have mattered I would have thought?
You were looking for a string that was "Forms![F_Start]![txt_UserName]", and unless someone had that name, you would never get a record.

If you had used Forms![F_Start]![txt_UserName] then Access would have looked at the value in that control and used that as the criteria, be it bound or unbound?