parameter query through form, report not showing anything.

[Lifeseeker]

Hi,

I'm creating a form through which users pass parameters into a query to generate a report. So on the form, there is "generate report" button.

There are only two fields of interest. On the search form, I have two unbound textboxes, which I turn into combo boxes, and these two combo boxes are each based on a query, not table. (so there is no table level look-up problem). The first unbound combo draws values from region, the other one draws value from local region. Region and local region are queries based off of tables.

The parameters for these two unbound fields are text-based, which I specified in the parameter window.

When I run the report by hitting "Report" button on the form, the report shows me no results even tho the first control has text in it. It seems that it's no going through the search-form. If I leave both controls empty, the report shows me all results.

Could anyone suggest me a method of diagnosis? WHat would be the problem? I'm having trouble. It's very simple form, but Access is just not cooperating...

thank you all

 

[mahdiswaidan11]

plz help me ..hi iam new here if some one can help me
iam made a query ...SELECT VisitD.VFirst ,VisitD.Valenter,VisitD.Valexit
FROM VistD
WHERE VisitID.Valenter < Text0.Value

this query is said to be opend in a subform in my form where instead of giving the value of the parameter in the popup box i want to give directly from a textbox which i will select from it a short date wheneve i press a buttom what i should do