Textbox based query returns blank

  • Thread starter Thread starter D.LopezIt
  • Start date Start date
D

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.
 
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."
 
Back
Top