Parameters not recognizing form data

[CarlyS]

I am trying to do something that should be quite simple and I cannot find what is going wrong.

I have a report based on a parameter query. There are two fields that prompt for parameters, NameField and DateField. When prompted for criteria it worked, but you had to enter the criteria as many as seven times, which is unacceptable. I tried to avoid this by having the parameters reference an unbound form.

The NameField criteria is this:
[Forms]![ChooseReportForm]![StudentFullName]

The DateField criteria is this:

Between [Forms]![ChooseReportForm]![Start] And [Forms]![ChooseReportForm]![End]

If I try to open the query I am prompted for this criteria and it works fine. When I try to use my form it retrieves no data. I am also making sure the form remains open and that doesn't seem to be the problem.

Is the problem that my form or my fields are unbound?

Any ideas?
I have also tried renaming forms and fields and that didn't seem to be the problem.

Carly

 

[WayneRyan]

Carly,

From reading it, you seem to be on the right track.

Can you post a sample?

Remove unneeded data/pictures.
Tools --> Database Utilities --> Compact/Repair
Then ZIP and attach.

Wayne

 

[CarlyS]

Ok, here it is. Thank you so much for taking a look at it!

The query pulls data if you just try to preview the data in datasheet view and manually enter the criteria. When you try to use the form it pulls nothing. See what you think...

 

[WayneRyan]

Carly,

I changed the Query so that the criteria for the name was "Combo17" and
it works fine.

It wasn't prompting me for anything, but wouldn't return any records
until I changed the Query's criteria.

Wayne

 

[CarlyS]

Thank you so much Wayne! What a silly mistake. I thought the problem was in the date field and totally overlooked that I made a change to the name field. Thank you so much for catching that!