Textbox based query returns blank

[D.LopezIt]

I have a textbox which displays data (Only numbers). Then I have a
button that calls a query thats supposed to return all the info from
the recordsource that matches the textbox. This is my query.

SELECT Draw_TBL.[Scope_#], Draw_TBL.[DWG_#], Draw_TBL.DWG_Name,
Draw_TBL.[Arc_DWG_#], Draw_TBL.[Structural_DWG_#], Draw_TBL.[Grid/
Loc], Draw_TBL.[Baker-submittal_#], Draw_TBL.[Baker-submittal_status],
Draw_TBL.[Baker-submittal_date], Draw_TBL.[POJV-submittal_#], Draw_TBL.
[POJV-submittal_status], Draw_TBL.[POJV-submittal_date], Draw_TBL.[BnA-
approval_status], Draw_TBL.[BnA-approval_date], Draw_TBL.DDA_Status,
Draw_TBL.DDA_Date
FROM Draw_TBL
WHERE Draw_TBL.[Scope_#]=Forms!ProjectList![Scope List]; <- Also tried
[Scope_#] but it doesn't work.

Problem is it returns blank. All the fields are there but no data.

 

[Al Campagna]

D,
We don't know your data, so we can only try general bug shooting
solutions.

I'd get rid of the # in any control names. Access uses # in Date
criteria. Can't be sure, but as a general rule... use something else. (Ex.
ScopeNo)

What happens when you "hard-wire" the query by using a legitimate ScopeNo
in the query...
Ex. = "ABC12345"

Place an unbound text cotrol on your form with...
=Forms!ProjectList![Scope List]
as the ControlSource. Does that show the value of [Scope_List]?

Remove all the fields from your query except
Draw_TBL.[Scope_#]
does that work?

If it works, start adding just a few fields to the query at a time, and
use that process to drill down to the problem.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."